Feature request: limit number of results

[sjoerd222888]

It would be nice to do something like

SELECT name FROM /myDir LIMIT 100

This should limit the number of results to maximum 100. This is an interesting feature when working with a huge amount of files.

Maybe even without the need to give a WHERE clause.

Alternative syntax could be:

SELECT TOP 100 name FROM /myDir

Example ese case: I would eventually like to be able to select a maximum of 100 files where the name starts with a certain letter. Ideally it would be possible to give a regex for the name (e.g. like in this library: https://github.com/gahag/FSQL).