SQLite JSON Query Tool

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