Skip to content

Feature request: Support collate option on orderByExpr #4498

@tjenkinson

Description

@tjenkinson

Is your feature request related to a problem? Please describe.
I'd like to be able to provide a custom COLLATE in an orderByExpr

Describe the solution you'd like
Maybe

export type SerializedOrderByClause = {
  column: string
  direction?: `asc` | `desc` // omitted means 'asc'
  nulls?: `first` | `last`
  collate?: string
}

which would compile to something like

ORDER BY c COLLATE "de_DE";

Metadata

Metadata

Assignees

No one assigned
    No fields configured for Feature.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions