[CALCITE-128] Support WITH queries (common table expressions)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:14
• Updated: 28/Oct/23 01:12
• Resolved: 18/Jun/14 08:14

Description

Optiq should support WITH queries, also known as common table expressions. These are essentially views, defined for the duration of the query.

See <a href="http://www.postgresql.org/docs/8.4/static/queries-with.html">Postgres documentation</a>.

Implementing the RECURSIVE keyword is a separate issue.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/128
Created by: julianhyde
Labels: enhancement,
Created at: Tue Feb 11 20:27:00 CET 2014
State: closed

Issue Links

• is required by: CALCITE-129 Support recursive WITH queries