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.)
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.)
SQLite has built-in JSON support: https://www.sqlite.org/json1.html
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.