I added `ORDER BY` and `LIMIT` to the Firestore query parser

Question

I added `ORDER BY` and `LIMIT` to the Firestore query parser and I decided to create a playground for it Run queries Load examples See intermediate representations

Tom Larkworthy · Answer

FWIW the most powerful and least understood semantics are the in and array contains any this is how you can do something similar to SQL joins efficiently

Tom Larkworthy · Answer

maybe you could translate SQL joins to clientside joins

Mariano Guerra · Answer

array operators are supported in the language

Tom Larkworthy · Answer

wait what are you building

Tom Larkworthy · Answer

oh yeah cool ```a == 4 and b in r and c lt 4 5 ORDER BY a b DESC c ASC LIMIT 5```

Mariano Guerra · Answer

we are adding firestore as a source on instadeq and until we have a visual query builder we needed a concise way to express queries that s why I build this it s just a way to take a query in and apply it to the firestore object

Mariano Guerra · Answer

at some point I will implement the visual query builder and this one will dissapear from the UI

Tom Larkworthy · Answer

yeah like a SQL translation layer yeah thats cool

Tom Larkworthy · Answer

BTW this popped up recently which seems to be trying to normalize access to DBs too <https observablehq com observablehq database client specification|https observablehq com observablehq database client specification> this is so their data cell query UI can hit multiple DB techs