Questions tagged [zio-quill]

I'm getting an error trying to filter based on ZonedDateTime using >. It works with ==. I'm using scala 3.2.0 and Quill 4.6.0. It seems it should work based on the Quill Docs. What could be missing? case class Post(id: Long, createdAt:…

I am using quill database library. my test code is along these lines: package dtest import io.getquill._ case class Cdl(id: Int, name: String) inline def cdl= quote { query[Cdl] } def testa = { val ctx=new PostgresJdbcContext(SnakeCase,…

I must work with 2 different databases: Oracle 11.2.0.3.0 Oracle 12.2.0.1.0 Using quill-jdbc-zio 4.6.0 (and zio 2.0.12 scala 2.13.10) I found that quill generate queries with using FETCH FIRST 2 ROWS ONLY that is no applicabe to Oracle 11. import…

groupByMap in ZIO Quill is throwing an exception when trying to group by on a query with a join. I'm using scala 3.2.0 and quill 4.6.0. What's the proper way to use group by on a join query in zio quill? case class Post(id: Long, title: String) case…