Project

General

Profile

Actions

Feature #14213

closed

Implement WITH in Wt::Dbo

Added by Matthias Van Ceulebroeck 7 months ago. Updated 2 days ago.

Status:
Closed
Priority:
Normal
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.

Actions #1

Updated by Romain Mardulyn about 2 months ago

  • Status changed from New to InProgress
  • Assignee set to Romain Mardulyn
Actions #2

Updated by Romain Mardulyn about 2 months ago

  • Status changed from InProgress to Review
  • Assignee deleted (Romain Mardulyn)
Actions #3

Updated by Romain Mardulyn about 2 months ago

  • Status changed from Review to InProgress
  • Assignee set to Romain Mardulyn
Actions #4

Updated by Romain Mardulyn about 2 months ago

  • Status changed from InProgress to Implemented @Emweb
  • Assignee deleted (Romain Mardulyn)
Actions #5

Updated by Romain Mardulyn 18 days ago

  • Status changed from Implemented @Emweb to Resolved
Actions #6

Updated by emil de keyser 17 days ago

  • Status changed from Resolved to InProgress
Actions #7

Updated by emil de keyser 17 days ago

  • Status changed from InProgress to Review
  • Assignee set to emil de keyser
Actions #8

Updated by Romain Mardulyn 8 days ago

  • Status changed from Review to Implemented @Emweb
  • Assignee changed from emil de keyser to Romain Mardulyn
Actions #9

Updated by Romain Mardulyn 2 days ago

  • Status changed from Implemented @Emweb to Closed
Actions

Also available in: Atom PDF