data-api-builder
data-api-builder copied to clipboard
Provide case (in)sensitive filtering through collations
The task is discussed here: https://github.com/Azure/project-hawaii/issues/11#issuecomment-1055396030
To achieve this we need to:
- know what collation a column is (and account for keeping this information up to date if the user can change it)
- know the equivalent collation of the existing collation which will provide case sensitive or insensitive comparison.
- make sure that the abovementioned equivalent collation exists / is recognized by the db (or if it doesn't exist, we error out)
All special case naming features (like aliasing or formatting column names to be GraphQL best practice) moved to Mar2023
Hi @Aniruddh25, as this was planned for March 2023, how can the filter be adjusted to be case sensitive or insensitive?