Hacker News new | ask | show | jobs
by trungdq88 2342 days ago
Interesting. How would you make this to support one-to-many/many-to-many relationships?
2 comments
mattatkeyboard 2342 days ago
You write the SQL into a JSON file. Users then can then execute that SQL with their own parameters. So the many-to-many is in your capability... A key reason for this is that it itself should not be clever.
link
BjoernKW 2342 days ago
This being a tabular visualisation of SQL result sets you'd either have duplication in some columns or aggregated results.

That's simply how SQL deals with 1:n and n:m relations.

link