4 ms·

Question: How easy / hard is it to replace a SQL query with a join, to a SQL query that returns a JSON object? (IE, a foreign key relationship is turned into a

Question: How easy / hard is it to replace a SQL query with a join, to a SQL query that returns a JSON object? (IE, a foreign key relationship is turned into a JSON array.)

datadrivenangel 1y ago
As in return the relation behind the join or return the results of that as a json object? The latter is easy with SQLites JSON support.
marcobambini 1y ago
SQLite has built-in JSON support: https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html