sql-studio
sql-studio copied to clipboard
Support multi-line output of queries
I.e. via this query I'm looking at using group_concat
with SQLite to produce a newline-delimited output like:
select
json_each.key as configuration_key,
group_concat(
platform || '/' || organisation || '/' || repo,
char(13)
) as repos,
count(*) as num_repos_with_config,
total_repos.c as total_repos
from
renovate_configs,
json_each(renovate_configs.config),
(
select
count(*) as c
from
renovate_configs
) as total_repos
group by
json_each.key
Which renders like so with sqlite3
:
However, when using sql-studio, we see: