sql-studio icon indicating copy to clipboard operation
sql-studio copied to clipboard

Support multi-line output of queries

Open jamietanna opened this issue 7 months ago • 0 comments

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:

2024-06-28-090148_873x382_scrot

However, when using sql-studio, we see:

2024-06-28-090229_1774x182_scrot

jamietanna avatar Jun 28 '24 08:06 jamietanna