Channels
administrivia
announcements
bot-dark-forest
devlog-together
in-alberta
in-boston
in-germany
in-israel
in-london
in-nyc
in-ontario
in-seattle
in-sf
in-socal
introduce-yourself
linking-together
of-ai
of-end-user-programming
of-functional-programming
of-graphics
of-logic-programming
of-music
present-company
random-encounters
reading-together
share-your-work
thinking-together
two-minute-week
wormholes
Title
m
Mariano Guerra
02/18/2022, 9:22 AMI added
ORDER BYLIMIT🍰 1
t
Tom Larkworthy
02/18/2022, 12:35 PMFWIW 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.
maybe you could translate SQL joins to clientside joins
m
Mariano Guerra
02/18/2022, 12:37 PMarray operators are supported in the language
t
Tom Larkworthy
02/18/2022, 12:38 PMwait what are you building?
oh yeah cool
a == 4 and b in ["r"] and c < 4.5 ORDER BY a, b DESC, c ASC LIMIT 5m
Mariano Guerra
02/18/2022, 12:47 PMwe 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
at some point I will implement the visual query builder and this one will dissapear from the UI
🍰 1
t
Tom Larkworthy
02/18/2022, 12:50 PMyeah like a SQL translation layer, yeah, thats cool!
BTW this popped up recently which seems to be trying to normalize access to DBs too https://observablehq.com/@observablehq/database-client-specification this is so their data cell query UI can hit multiple DB techs
👏🏽 1