This feature is specific to PostgreSQL. It's not part of the official SQL standard, but as I've seen this statement type being used out there, I'm opening this issue anyway to bring attention to it and discuss whether JSQLParser should support it, especially since PostgreSQL is becoming increasingly popular over the last few years.
Relevant PG docs: https://www.postgresql.org/docs/current/queries-with.html
Steps to reproduce:
WITH devices AS NOT MATERIALIZED (
SELECT
d.uuid AS device_uuid
FROM active_devices d
)
SELECT 1;
Parsing error:

This feature is specific to PostgreSQL. It's not part of the official SQL standard, but as I've seen this statement type being used out there, I'm opening this issue anyway to bring attention to it and discuss whether JSQLParser should support it, especially since PostgreSQL is becoming increasingly popular over the last few years.
Relevant PG docs: https://www.postgresql.org/docs/current/queries-with.html
Steps to reproduce:
Parsing error: