Called when building a ``SELECT`` statement, position is just before column list.
(self, select: Select[Any], **kw: Any)
| 5427 | return "WITH" |
| 5428 | |
| 5429 | def get_select_precolumns(self, select: Select[Any], **kw: Any) -> str: |
| 5430 | """Called when building a ``SELECT`` statement, position is just |
| 5431 | before column list. |
| 5432 | |
| 5433 | """ |
| 5434 | if select._distinct_on: |
| 5435 | util.warn_deprecated( |
| 5436 | "DISTINCT ON is currently supported only by the PostgreSQL " |
| 5437 | "dialect. Use of DISTINCT ON for other backends is currently " |
| 5438 | "silently ignored, however this usage is deprecated, and will " |
| 5439 | "raise CompileError in a future release for all backends " |
| 5440 | "that do not support this syntax.", |
| 5441 | version="1.4", |
| 5442 | ) |
| 5443 | return "DISTINCT " if select._distinct else "" |
| 5444 | |
| 5445 | def group_by_clause(self, select, **kw): |
| 5446 | """allow dialects to customize how GROUP BY is rendered.""" |