PostgreSQL - `SELECT FROM ( VALUES (), () )` expression is not supported

[OfekTeken]

PostgreSQL - `SELECT FROM ( VALUES (), () )` expression is not supported

[griffio]

It should work with a CTE , but there is an issue with BOOLEAN literals - I have fixed as part of #5253

e.g

WITH x(some_boolean, tbl2_name) AS (
    VALUES
    (TRUE, 'name1'),
    (FALSE, 'name2')
)
INSERT INTO table1(some_boolean, tbl2_id)
SELECT some_boolean, tbl2.id
FROM x JOIN table2 AS tbl2 ON name = x.tbl2_name;

Subqueries with a column list such as https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-SUBQUERIES , isn't currently implemented as the original core grammar is for Sqlite.
e.g

FROM (VALUES ('anne', 'smith'), ('bob', 'jones'), ('joe', 'blow'))
     AS names(first, last)

[OfekTeken]

@griffio Thanks for your response :)
Good to know that this could work with a CTE, but what if the number of insertion values aren't pre-defined? Meaning, it could be n number of entries at runtime (This could be referenced to #5254).

Regarding the core of the issue, I think that if it's possible from within a CTE that it's probably not that big of a deal, but still - It might be beneficial to support it to allow a wider range of queries supported by SQLDelight. (As per your example with SQLite)