Skip to content

[FEATURE] NOT MATERIALIZED not supported in CTE #2251

@tomershay

Description

@tomershay

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:

Image

Metadata

Metadata

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions