SQLite JSON Query Builder
The JSON API of SQLite allows new ways to combine multiple queries together. However, in order to create JSON objects, all of the column names must be known ahead of time. This can be a bit tedious to get right.
This tool will try to auto-detect your column names and generate a wrapper query that is ready to go without any dependencies.
Detected columns: id, name, my_rank
Wrapped query:
select json_object(
'my_query',
(
select json_group_array(
json_object('id', id, 'name', name, 'my_rank', my_rank)
)
from (
select
id,
employees.name,
ranking as my_rank
from
employees
limit
2
)
)
) as json_result