Ecosyste.ms: Issues
An open API service for providing issue and pull request metadata for open source projects.
GitHub / tobymao/sqlglot issues and pull requests
#3534 - Snowflake Alter Table ... Alter Column ... DROP NOT NULL doesn't parse correctly
Issue -
State: closed - Opened by barino86 5 months ago
- 6 comments
#3531 - feat(optimizer)!: Expand stars on BigQuery's tbl.struct_col.* selections
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 1 comment
#3531 - feat(optimizer)!: Expand stars on BigQuery's tbl.struct_col.* selections
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 1 comment
#3488 - Presto to spark conversion flattens subqueries with invalid ordering
Issue -
State: open - Opened by williaster 5 months ago
#3487 - Refactor(presto): make DELETE transpilation more robust
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3486 - Fix(tsql)!: parse TININT into UTINYINT to improve transpilation
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3485 - feat!: Add ALTER TABLE SET
Pull Request -
State: open - Opened by VaggelisD 5 months ago
#3484 - Expanding nested star selects gives an error in Bigquery syntax
Issue -
State: closed - Opened by Bladieblah 5 months ago
- 11 comments
#3483 - Refactor: clean up Hex / LowerHex implementation
Pull Request -
State: closed - Opened by georgesittas 5 months ago
- 1 comment
#3482 - Fix(mysql): generate CONCAT for DPipe
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3481 - [bug] pgsql to mysql special character || Semantic mismatch
Issue -
State: closed - Opened by Toms1999 5 months ago
- 1 comment
#3480 - Feature Request: Support for Materialized View Rewriting in SQL Optimizer
Issue -
State: closed - Opened by Smallhi 5 months ago
- 1 comment
#3479 - bigquery dialect converting UNION to UNION DISTINCT
Issue -
State: closed - Opened by sumeet-wisdom 5 months ago
- 1 comment
#3478 - Fix(duckdb): preserve precedence of json extraction when converting to arrow syntax
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3477 - Fix(snowflake)!: preserve star clauses (EXCLUDE, RENAME, REPLACE)
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3476 - Inconsistent conversion of JSON functions for DuckDB
Issue -
State: closed - Opened by asiunov 5 months ago
- 1 comment
#3475 - Incorrect conversion of SELECT with REPLACE to RENAME for Snowflake
Issue -
State: closed - Opened by asiunov 5 months ago
- 1 comment
#3474 - Fix: allow parameters in user-defined types
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3473 - Feat(snowflake): add support for CREATE TAG DDL statement
Pull Request -
State: closed - Opened by georgesittas 5 months ago
- 1 comment
#3472 - Refactor(snowflake)!: set default precision / width for DECIMAL type
Pull Request -
State: closed - Opened by georgesittas 5 months ago
- 1 comment
#3471 - feat: improve transpilation of UnixToTime (postgres, mysql, clickhouse)
Pull Request -
State: closed - Opened by longxiaofei 5 months ago
- 3 comments
#3470 - Fix: preserve quotes for projections produced by the eliminate_qualify rule
Pull Request -
State: closed - Opened by aersam 5 months ago
- 1 comment
#3468 - Parse CREATE TAG (Snowflake)
Issue -
State: closed - Opened by tekumara 5 months ago
- 2 comments
#3467 - Sqlglot produces Syntax Error on rewriting QUALIFY
Issue -
State: closed - Opened by aersam 5 months ago
- 1 comment
#3466 - fix(presto): fix DELETE DML statement for presto/trino
Pull Request -
State: closed - Opened by viplazylmht 5 months ago
- 1 comment
#3465 - feat(clickhouse): add support for PROJECTION in CREATE TABLE statement
Pull Request -
State: closed - Opened by GaliFFun 5 months ago
- 1 comment
#3464 - Fix(optimizer): fix multiple bugs in unnest_subqueries, clean up test suite
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3463 - feat(transpiler): handle different hex behavior for dialects
Pull Request -
State: closed - Opened by viplazylmht 5 months ago
- 6 comments
#3462 - feat: Add T-SQL DECLARE statement parsing
Pull Request -
State: closed - Opened by jlucas-fsp 5 months ago
- 11 comments
#3461 - sqlglot parsing error for specific SQL query
Issue -
State: closed - Opened by MNIKIEMA 5 months ago
- 2 comments
#3460 - Behavior of HEX function is different between dialects
Issue -
State: closed - Opened by viplazylmht 5 months ago
- 3 comments
#3459 - fix(presto): fix parsing and generating hash functions presto/trino
Pull Request -
State: closed - Opened by viplazylmht 5 months ago
#3458 - Incorrect parsing and generating of SHA, SHA2, MD5, and MD5_Digest expressions in Presto/Trino dialect
Issue -
State: closed - Opened by viplazylmht 5 months ago
#3457 - Feat!: improve transpilation of TABLESAMPLE clause
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3456 - Rendering of `TABLESAMPLE` yields invalid `PERCENT` keyword for Postgres dialect
Issue -
State: closed - Opened by whummer 5 months ago
- 2 comments
#3455 - Trino/Presto dialect regression/change starting in 23.11.0? (table identifier quoted attribute ignored)
Issue -
State: closed - Opened by forgeljet 5 months ago
- 2 comments
#3454 - fix(clickhouse): fix parsing and generating hash functions
Pull Request -
State: closed - Opened by viplazylmht 5 months ago
- 2 comments
#3453 - fix(bigquery): fix SHA1 generator
Pull Request -
State: closed - Opened by viplazylmht 5 months ago
- 2 comments
#3452 - Incorrect parsing and generating of SHA, SHA2, MD5, and MD5_Digest expressions in clickhouse dialect
Issue -
State: closed - Opened by viplazylmht 5 months ago
#3451 - Incorrect generating of SHA expression to bigquery dialect
Issue -
State: closed - Opened by viplazylmht 5 months ago
#3450 - feat: add support for ON property in ALTER and DROP statements
Pull Request -
State: closed - Opened by GaliFFun 5 months ago
#3449 - fix(snowflake): COPY Subquery postfix
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3448 - Oracle to Spark SQL. Failure to unnest queries during optimisation
Issue -
State: closed - Opened by yesemsanthoshkumar 5 months ago
#3447 - Fix(executor): use timezone-aware object to represent datetime in UTC
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3446 - Fix(duckdb): use name sequence instead of single _t for unnest alias
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3445 - fix: improve error handling for nested schema levels
Pull Request -
State: closed - Opened by tobymao 5 months ago
#3444 - Feat(redshift): improve ALTER TABLE .. ALTER .. support
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3443 - fix(presto,trino,clickhouse,bigquery): fix behavior of some hash and ecoding functions
Pull Request -
State: closed - Opened by viplazylmht 5 months ago
- 5 comments
#3442 - expression.AlterTable doesn't seem to support dropping columns
Issue -
State: closed - Opened by ikasovitch 5 months ago
- 4 comments
#3441 - feat(clickhouse): add support for ALTER TABLE REPLACE PARTITION statement
Pull Request -
State: closed - Opened by GaliFFun 5 months ago
- 4 comments
#3440 - fix: func to binary MOD generation
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3439 - Expression .sql() function preserve comments when comments=False.
Issue -
State: closed - Opened by CBQu 5 months ago
#3438 - Expanding diff to compare 2 SQL documents
Issue -
State: closed - Opened by ikasovitch 5 months ago
- 4 comments
#3437 - Fix: handle empty string in connector comment padding
Pull Request -
State: closed - Opened by uncledata 5 months ago
- 4 comments
#3436 - Fix(snowflake): parse CREATE SEQUENCE with commas
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3435 - Allow comma-separated values for `CREATE SEQUENCE` properties (Snowflake)
Issue -
State: closed - Opened by whummer 5 months ago
#3434 - Parsing issue for Snowflake COPY INTO queries with subqueries
Issue -
State: closed - Opened by whummer 5 months ago
#3433 - Incorrect generation of string concatenation to postgres
Issue -
State: closed - Opened by marcobjorge 5 months ago
- 1 comment
#3432 - Unable to parse Trino WITH FUNCTION clause
Issue -
State: closed - Opened by john-bodley 5 months ago
- 4 comments
#3431 - Incorrect transpiling of MOD function from trino to snowflake
Issue -
State: closed - Opened by daniel769 5 months ago
#3430 - Chore: bump ruff to 0.4.3
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3429 - Missing tokens for Oracle datatypes.
Issue -
State: closed - Opened by ganeshdogiparthi-db 5 months ago
- 1 comment
#3428 - feat(clickhouse): add support for partition expression
Pull Request -
State: closed - Opened by GaliFFun 5 months ago
#3427 - fix(mssql) : adding support for TOP
Pull Request -
State: closed - Opened by gitvibav 5 months ago
- 3 comments
#3426 - feat(snowflake): Support for APPROX_PERCENTILE
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3425 - fix(mysql): Parse REPLACE statement as Command
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3424 - APPROX_PERCENTILE is translated from Trino to APPROX_QUANTILE in Snowflake, which does not exist in Snowflake
Issue -
State: closed - Opened by baruchoxman 5 months ago
#3423 - support "replace into"
Issue -
State: closed - Opened by DyCheer 5 months ago
- 1 comment
#3422 - Updated tokens.py
Pull Request -
State: closed - Opened by gitvibav 5 months ago
- 3 comments
#3421 - extract SQL query keywords from a sql query
Issue -
State: closed - Opened by MohammadrezaPourreza 5 months ago
- 1 comment
#3420 - Getting an unexpected parse error: Expected AS after CAST
Issue -
State: closed - Opened by MatKadd 5 months ago
- 3 comments
#3419 - Fix(snowflake): ensure OBJECT_CONSTRUCT is not generated inside of VALUES
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3418 - Fix(lineage): get rid of comments in Node names
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3417 - Fix!: parse column instead of identifier for SET assignment LHS
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3416 - To_utc_timestamp converts to from_utc_timestamp when using dialect = "databricks"
Issue -
State: closed - Opened by dominikpeter 5 months ago
- 2 comments
#3415 - SET TAG identifier containing dots is parsed as Command
Issue -
State: closed - Opened by tekumara 5 months ago
#3414 - lineage returns sql comments as part of node name
Issue -
State: closed - Opened by jaspev123 5 months ago
- 2 comments
#3413 - Preserve casing of quoted identifiers for SQL function calls [Snowflake/Postgres]
Issue -
State: closed - Opened by whummer 5 months ago
- 1 comment
#3412 - [feature] Support for concatenation operator "||"
Issue -
State: closed - Opened by iNSDX 5 months ago
- 2 comments
#3411 - [bug] when postgres sql to mysql sql substring is bug
Issue -
State: closed - Opened by Toms1999 5 months ago
- 8 comments
#3410 - SQL with GROUPING SETS transpiled unexpectedly from Spark to Trino
Issue -
State: closed - Opened by Jake-00 5 months ago
- 12 comments
#3409 - Optimize translates query into different dialect
Issue -
State: closed - Opened by raeudigerRaeffi 5 months ago
- 1 comment
#3408 - Chore: release sqlglotrs only when Cargo.toml is updated
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3407 - oracel to hive query
Issue -
State: closed - Opened by Maheshkumar094 5 months ago
- 2 comments
#3406 - Chore: improve unsupported error documentation
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3405 - fix(trino|presto): adding cast support for "hyperloglog" column type
Pull Request -
State: closed - Opened by uncledata 5 months ago
- 3 comments
#3404 - Flink sql support
Issue -
State: closed - Opened by tonyxiao 5 months ago
- 1 comment
#3403 - Feat(postgres): add support for anonymos index DDL syntax
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3402 - fix(trino): support for data type 'tdigest'
Pull Request -
State: closed - Opened by suryaiyer95 5 months ago
#3401 - Fix(tsql): quote hash sign as well for quoted temporary tables
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3400 - BigQuery - Changing any table name part does not work properly when the entire table name is surrounded by backticks
Issue -
State: closed - Opened by jvaesteves 5 months ago
- 2 comments
#3399 - bug(mssql): incorrect syntax for creating quoted temporary table
Issue -
State: closed - Opened by gforsyth 5 months ago
- 2 comments
#3398 - fix(snowflake): COPY postfix
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 2 comments
#3397 - Support for Databricks GENERATED ALWAYS AS (expr) is incomplete
Issue -
State: closed - Opened by crash-g 5 months ago
#3396 - Feat: Set lineage node's reference name to its alias for derived tables
Pull Request -
State: closed - Opened by vchan 5 months ago
#3395 - Feat(prql): add support for AGGREGATE
Pull Request -
State: closed - Opened by fool1280 5 months ago
#3394 - Fix!: get rid of superfluous "parameters" arg in RegexpReplace
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3393 - sqlglot removes options from the regexp_replace function
Issue -
State: closed - Opened by rzykov 5 months ago
- 1 comment
#3392 - Fix(postgres): tokenize INT8 as BIGINT
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3391 - [BUG]In PostgreSQL, int8 represents the 64-bit integer type, not tinyint
Issue -
State: closed - Opened by fuzi1996 5 months ago