database/gdb: 希望 ORM 支持 With CTE 表达式和横向关联(Lateral Join)的构建

[FlashIvano]

Is your feature request related to a problem?

Option Yes

Describe the solution you'd like

Common Table Expressions (CTE) 和横向关联常用的 SQL 语法，主流数据库都早已支持。
希望 orm 可以支持。

语法参考：
PGSQL:
CTE: https://www.postgresql.org/docs/current/queries-with.html
Lateral: https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL
MySQL:
CTE: https://dev.mysql.com/doc/refman/8.4/en/with.html
Lateral: https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html

Describe alternatives you've considered

无

Additional

No response