electric-sql / electric-sql/electric

Feature request: Support `collate` option on `orderByExpr`

Open
#4,498 0 comments 0 reactions 0 assignees View on GitHub
feature request triage
Dominant language
TypeScript
Stars
10.4k
Forks
375
Avg merge
3d 1h
Merged PRs (30d)
18

Description

**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
```ts
export type SerializedOrderByClause = {
column: string
direction?: `asc` | `desc` // omitted means 'asc'
nulls?: `first` | `last`
collate?: string
}
```

which would compile to something like
```sql
ORDER BY c COLLATE "de_DE";
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.