4 ms·
This is cool. I like that it makes it super easy to get data into the database rather than having to meddle with schemas in advance. Looked through the documen
by matlin 3y ago
This is cool. I like that it makes it super easy to get data into the database rather than having to meddle with schemas in advance.
Looked through the documentation briefly but couldn't figured out how selecting nested properties or filtering on nested properties works?
- deobald 3y agoI think the documentation you're looking for is here: https://docs.endatabas.com/sql/path_navigation.html https://docs.endatabas.com/sql/path_navigation.html I've just pushed a change mentioning that paths can be used in both SELECT and WHERE clauses. Sorry for the ambiguity. For example: `select * from stores where addresses[0].city = 'New Jersey';` ...can be used on the demo data, found here: https://www.youtube.com/watch?v=oDHGjUMqPvI&t=140s https://www.youtube.com/watch?v=oDHGjUMqPvI&t=140s - demo https://github.com/endatabas/marketing/tree/main/2023-09-demo https://github.com/endatabas/marketing/tree/main/2023-09-dem... - code HTH!