sqlgg
sqlgg copied to clipboard
ygrek
SQL Guided (code) Generator
Adding support for MySQL's `STRAIGHT_JOIN` defined here: https://dev.mysql.com/doc/refman/8.0/en/join.html
In Postgres function created by `CREATE FUNCTION` can be schema qualified. `sqlgg` doesn't support that and fails to parse such statement. `CREATE PROCEDURE` can also be schema qualified. https://www.postgresql.org/docs/current/sql-createfunction.html ```...
This pull request enhances the coalesce function to provide accurate type inference. Previously, coalesce didn't behave as expected, but with this update, it correctly outputs a not null type if...
### Description This pull request addresses an issue in join operations where column types displayed for requested columns are overridden by types from the tables, leading to inaccuracies. Specifically, in...
## Change: Default to NULL for Fields without explicit NOT NULL ### Description This change ensures that fields without explicit NOT NULL are defaulted to NULL. ### Details - Fields...
This PR implements an alternative to #117, making tracing-information non-optional (and thus requiring no build-system changes), instead requiring traits-implementations to be updated to accept the new tracing-information. This is a...
This PR adds two tests to ensure proper handling of NULL values by the COALESCE function in various scenarios. - COALESCE correctly handles first not nullable argument. - COALESCE does...
#### These test shows required improvements to make JOINS work properly. When dealing with a LEFT JOIN, nullability arises under the following scenarios: 1. **No Foreign Key:** - If there...
nullability depends on the nullability of the last argument
