Rob W

add round trip testing for all column types (postgres module)

1

This should use zio-sql to insert values into the database, then read them back out, and ensure they're the same as the ones that went in. This is dependent on...

support custom renderings for functions with odd syntax

1

discovered by @marcinkrykowski in #245 e.g. overlay needs specific keywords inserted between arguments `overlay( placing from [ for ] )` I'll be working on this one

Support support context bounds on `FunctionDef`s

1

There are lots of `FunctionDef`s that should work for multiple types specified by existing parameter bounds e.g. ```scala val Sign = FunctionDef[Double, Int](FunctionName("sign")) ``` it would be good to be...

`select * from a where a.id in (select id from b where something)` is a fairly common pattern in sql which zio-sql doesn't currently support. ```scala val deleteFromWithSubquery = deleteFrom(orders).where(fkUserId...

need to be able to delete from joined tables

1

split from #37 All major dialects provide some way to delete from a joined table but the table to be deleted from needs to be explicitly provided. We could specify...

syntax for `in` isn't very fun for a literal set ```scala deleteFrom(users) where (fName in Read.lit("Fred", "Terrance")) ``` it'd be much better if we could have something like ```scala deleteFrom(users)...

Report compiler crashes to the client instead of silently failing

7

### Is your feature request related to a problem? Please describe. I'm having a lot of compiler crashes using scala 3. These crashes are transparent to me when using metals...

Please consider upstreaming to Scala3

1

Hi, thanks for the awesome library! I'm using heaps of unions so this is a lifesaver. Would you consider upstreaming this to Scala3? I think this is a missing feature...

> "Direct quote or clear summary of user request or need or user story." ### Motivation Using lots of different AI tools has meant setting up the same MCP tools...