search

zio / zio-quill

Compile-time Language Integrated Queries for Scala
https://zio.dev/zio-quill
Apache License 2.0
2.15k stars 349 forks source link

Enhancement: support JSON operations for SQLite #2739

Open vladimir-lu opened 1 year ago

vladimir-lu commented 1 year ago

Version: 4.6.0 Module: quill-jdbc Database: sqlite

Expected behavior

Since sqlite 3.38.0 JSON support has been baked in: https://www.sqlite.org/json1.html

It would be nice if both the json type and json functions were supported (similar to the postgres dialect https://github.com/zio/zio-quill/pull/2615) .

Actual behavior

Only Postgres is supported

Steps to reproduce the behavior

N/A

Workaround

Write manual encoders/decoders + infix operators

@getquill/maintainers

vladimir-lu commented 1 year ago

I will probably come up with some version of this for my own use and update here based on how nice it looks.