griff і⊙

I should also add that support for PostgreSql `tsrange/tstzrange` as an alternative data type for storing temporal values is still in PR stage https://github.com/sqldelight/sqldelight/pull/5297.

📸 The snapshot version seems to work `2.1.0-SNAPSHOT` - in a small sample app Previously I fixed an issue with Sqlite Windows as they didn't really work https://github.com/sqldelight/sqldelight/pull/5406 📓 Using...

Can confirm - it's specifically using the `VALUES ?` special SqlDelight syntax It should work with```INSERT INTO "order" (id) VALUES (?);```

@frevib issue has come up before https://github.com/cashapp/sqldelight/issues/4877 and is not specific to Postgresql Dialect For fixing bugs, only some basic overview is given here https://github.com/cashapp/sqldelight/blob/6fa1522ca3e87b8e1379891a7d30422489198753/CONTRIBUTING.md - sadly it requires lots...

Another issue is that sometimes the problem is located in the [SqlPsi](https://github.com/AlecKazakova/sql-psi) project e.g This problem could be here ??? -> https://github.com/AlecKazakova/sql-psi/blob/9d51d00e622afe3cc06c722f9cf8181b89b8dd30/core/src/main/kotlin/com/alecstrong/sql/psi/core/psi/SqlNamedElementImpl.kt#L25 The table name is being trimmed from ""order""...

😞 Sadly `DROP CONSTRAINT` is not implemented I will add it to the list https://github.com/griffio/sqldelight-postgres-01 and see if it can be quickly implemented

🤔 Tested with latest snapshot as been many updates Seems to compile using `CAST` ... `AS INTEGER` - NOT INT Still a 🐛 but may help you make progress for...

Similar issue https://github.com/sqldelight/sqldelight/issues/4468

I will have a look at some point as likely from `sql-psi 0.5.0` updated recently As a work around the equivalent query does work - so there maybe something in...