zio-sql
zio-sql copied to clipboard
zio
Type-safe, composable SQL for ZIO applications
Consider a following self-referencing schema: ```sql CREATE TABLE items ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL, parent_id INTEGER, CONSTRAINT fk_parent_id FOREIGN KEY (parent_id) REFERENCES items(id) )...
Consider a following self-referencing schema: ```sql CREATE TABLE items ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL, parent_id INTEGER, CONSTRAINT fk_parent_id FOREIGN KEY (parent_id) REFERENCES items(id) )...
Depends on https://github.com/zio/zio-sql/issues/148 We need a full-stack test for Oracle. We need an automated ZIO Test that, when run, will execute a simple query, such as `select 1`, against a...
`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...
We need a few examples of UPDATE queries under different schemas, both to validate the design and flesh out edge cases, as well as to show people how to use...
Currently, `Expr` is closed, and subtypes of the `Sql` module cannot add new expressions. This is inconvenient as different dialects of SQL support different constructs. To support extensibility, we can...
Openning as a draft PR, want to show first PoC. Still missing mysql for example. Idea behind this solution is that, we generate table alias **only** when table is used...
`SELECT a.name, v.address FROM (VALUES('101 Main St City USA', 'foo', 'bar'), ('24 Sussex Drive Ottawa Canada', 'foo2', 'bar2')) vals(address, foo, bar) CROSS JOIN A` with any kinds of joins being...
I believe they are fairly standard for modify DML statements as well. This minimally looks like this syntax `WITH...`
Currently, when a `SELECT` is executed, if any row contains a null and the user's data model cannot accommodate it, then the whole query will fail. It would be more...