Support for Postgres ?| operator (do any of these array strings exist as top-level keys)

kysely-org / kysely

A type-safe typescript SQL query builder

https://kysely.dev

MIT License

9.82k stars 250 forks source link

Support for Postgres ?| operator (do any of these array strings exist as top-level keys) #1002

Closed soanvig closed 1 month ago

soanvig commented 1 month ago

Postgres supports ?| operator https://www.postgresql.org/docs/9.5/functions-json.html however Kysely does not:

invalid operator "?|"
      at parseOperator (../node_modules/.pnpm/kysely@0.27.3/node_modules/kysely/dist/cjs/parser/binary-operation-parser.js:69:11)

is that intended thing to not support, or is it an overlook?

koskimas commented 1 month ago

Just an oversight. We can add it