Query result from sqlite hides columns with same name

[izderadicka]

Describe the bug
I'm running this query against Postgres and SQLite:

select a.first_name,
    a.last_name,
    e.title,
    s.title,
    e.series_index,
    g.name
FROM author a
    join ebook_authors l on a.id = l.author_id
    JOIN ebook e on l.ebook_id = e.id
    left JOIN ebook_genres ll on e.id = ll.ebook_id
    left JOIN genre g on g.id = ll.genre_id
    left JOIN series s on s.id = e.series_id
order by e.id
limit 100;

While on results from Postgres, I see all expected columns, on result from from Sqlite one title column is missing (e.title).

When running in sqlite3 CLI also two columns are displayed (both have same name)

To Reproduce
Steps to reproduce the behavior:

1. Create connection to Sqlite DB
2. Run query as shown above
3. Result - shown in table - is missing one column

Expected behavior
See both title columns - same as it works for postgress and sqlite3 CLI

Screenshots
Correct output from Postgres:

Missing column in Sqlite result:

All OK in sqlite3 CLI:

Desktop (please complete the following information):

• SQLTools Version 0.28.4, SQLite 0.5.2
• VS Code Version: 1.98.2
• OS: Linux Ubuntu 22
• Driver:
  • [X ] PostgreSQL/Redshift
  • MySQL/MariaDB
  • MSSQL/Azure
  • [X ] SQLite
  • Other? Which...
• Database version: Sqlite 3.37.2 2022-01-06, Postgres 15

Additional context
Add any other context about the problem here.

[gjsjohnmurray]

The fix for this in the PostgreSQL driver was apparently done in #485