Skip to content

Support multi-line output of queries #30

Open
@jamietanna

Description

@jamietanna

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions