Comments (5)
The reason it was originally left open was because the issue requested "under multiple schemas", but I'm not sure we need additional schemas - I think there's enough there to do most queries you're going to see in the wild.
from zio-sql.
I'll take this one and #12 #13 #14 #16 - I'll need these for #8 and will probably come up with more edge cases from doing that. From watching the video I'm 90% sure I can write at least some queries that will compile but won't be valid sql and vice versa. I also have some suspicions on group by.
delete from a left join b on a.id = b.id where b.c = d
this isn't valid but I think will probably compile
delete a from a left join b on a.id = b.id where b.c = d
this is valid but I don't think we can currently form this statement
guess I'll find out soon enough!
from zio-sql.
Awesome, appreciate the identification of edge cases too!
from zio-sql.
@robmwalsh can this issue be closed (and related mentioned by you)?
from zio-sql.
Ok, so I think I'll close these issues, as it's getting harder and harder to keep up with what is actually to do.
And yeah, I think the current examples are sufficient for now and we can expand them as needed.
from zio-sql.
Related Issues (20)
- Unable to resolve aggregate functions
- Syntax Errors in shop.sql File
- Add `hex` function to MysqlSqlModule HOT 2
- Add `soundex` function to MysqlSqlModule HOT 2
- Implement `SOUNDS LIKE` as a dialect-specific operator for MySQL HOT 2
- Update ZIO SQL to use ZIO JDBC
- Adopt ZIO JDBC model for transactions HOT 1
- Testcontainers not closing correctly after tests HOT 1
- Add examples for inserts HOT 1
- Add examples for union/unionAll HOT 1
- Clean up FunctionDefSpec HOT 1
- Add `jsonb` support for PostgreSQL
- Add support for Sum(BigDecimal) function HOT 1
- Invalid connections are placed back in the `ConnectionPool` HOT 1
- Improve FunctionDefSpec
- No postgres module release for scala 3 HOT 1
- Support INSERT without specifying columns
- Using zio-sql with Scala 3 HOT 1
- Unable to run example code HOT 2
- Include batch update and batch delete into the SqlTransaction HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from zio-sql.