sql

All things SQL and JDBC...
orestis 2020-10-15T17:31:51.102600Z

If you use unique names things like powerbi can infer relationships, apparently- even without FKs.

seancorfield 2020-10-15T17:35:11.104600Z

FWIW, next.jdbc's datafy/`nav` across result sets assumes :table_id (or :tableid) could be a FK relationship to :table.id, i.e., address.user_id in the address table will be assumed to link via select * from user where id = <address.user_id> when you navigate.

seancorfield 2020-10-15T17:35:29.105Z

(but you can provide your own :schema option to override that if you want)