Project

General

Profile

Actions

Feature #14213

open

Implement WITH in Wt::Dbo

Added by Matthias Van Ceulebroeck 4 days ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
Start date:
12/17/2025
Due date:
% Done:

0%

Estimated time:

Description

Since WITH is supported over nearly all Dbo backends, we can integrate that in Wt::Dbo as well.
See: https://modern-sql.com/feature/with#compatibility

Firebird is not part of this overview but ought to support it too: https://firebirdsql.org/rlsnotesh/rnfb210-dml.html#rnfb210-cte
This may require an upgrade of IBPP.

The WITH clause allows for common table expressions to be defined, which allows queries to be more dynamic, and recursive.

No data to display

Actions

Also available in: Atom PDF