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
#3390 - fix(optimizer)!: Mark UDTF child scopes as ScopeType.SUBQUERY
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3389 - Fix: allow joins in FROM expression parser
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3388 - Version 23.12.2 fails to parse some COPY clauses
Issue -
State: closed - Opened by dangoldin 5 months ago
- 11 comments
#3387 - Update with join seems to be unsupported
Issue -
State: closed - Opened by MikeWallis42 5 months ago
#3386 - feat!: Introducing TIMESTAMP_NTZ token and data type
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3385 - Fix(trino): bring back TRIM parsing
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3384 - Can't parse `trim` in TrinoSQL
Issue -
State: closed - Opened by dmelchor-stripe 5 months ago
#3383 - fix(postgres): Infer FROM clause in parse_substring()
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 1 comment
#3382 - fix(duckdb): Preserve DATE_SUB roundtrip
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 1 comment
#3381 - T-SQL and Text Data Types
Issue -
State: closed - Opened by aersam 5 months ago
- 2 comments
#3380 - fix(optimizer): Remove XOR from connector simplifications
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 4 comments
#3379 - Support for Spark's new Timestamp_Ntz and Timestamp_Ltz is missing
Issue -
State: closed - Opened by aersam 5 months ago
#3378 - Support for generation of different SQL
Issue -
State: closed - Opened by Beliefuture 5 months ago
- 4 comments
#3377 - [postgres] ParseError , substring def
Issue -
State: closed - Opened by Toms1999 5 months ago
- 3 comments
#3376 - Fix(spark): transpile presto TRY, fix JSON casting issue
Pull Request -
State: closed - Opened by georgesittas 5 months ago
- 1 comment
#3375 - Fix(mysql): don't cast into invalid numeric/text types
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3374 - Presto to Spark query translation incorrect
Issue -
State: closed - Opened by cploonker 5 months ago
#3373 - Syntactically incorrect result produced when using DuckDB `date_sub` as an input
Issue -
State: closed - Opened by zergar 5 months ago
#3372 - XOR transformed into an OR depending on the alphabetical order of operands
Issue -
State: closed - Opened by colincointe 5 months ago
- 1 comment
#3371 - Refactor: don't mutate the AST when creating DDL scopes
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3370 - Fix(mysql): generate GROUP_CONCAT for ArrayAgg
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3369 - Fix(mysql): convert epoch extraction into UNIX_TIMESTAMP call
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3368 - Mysql syntax not fully supported/accurate
Issue -
State: closed - Opened by FaizelK 5 months ago
- 4 comments
#3367 - feat(mysql): Transpile TimestampTrunc
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3366 - Timestamp trunc method issue from postgres to MySQL
Issue -
State: closed - Opened by sivpr2000 5 months ago
- 5 comments
#3365 - [bug] postgres sql to doris sql fail
Issue -
State: closed - Opened by Toms1999 5 months ago
- 4 comments
#3364 - Fix(postgres): don't generate SchemaCommentProperty
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3362 - oracle to pyspark sql query convertion
Issue -
State: closed - Opened by ACHINTA-MONDAL 5 months ago
- 1 comment
#3361 - SQL with `GROUPING SETS` transpiled unexpectedly from Spark to Trino
Issue -
State: closed - Opened by Jake-00 5 months ago
- 3 comments
#3360 - Fix(lineage): use source names of derived table sources for laterals
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3359 - feat: COPY TO/FROM statement
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
- 1 comment
#3358 - Fix: export optimizer functions explicitly in init
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3357 - Fix(postgres): don't generate CommentColumnConstraint
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3356 - No `source_name` in column lineage with `LATERAL FLATTEN`
Issue -
State: closed - Opened by eliaperantoni 5 months ago
#3355 - fix: export optimize
Pull Request -
State: closed - Opened by tekumara 5 months ago
- 1 comment
#3354 - "optimize" is not exported from module "sqlglot.optimizer"
Issue -
State: closed - Opened by tekumara 5 months ago
- 2 comments
#3353 - DESCRIBE expressions throw ParseError (duckdb)
Issue -
State: closed - Opened by tekumara 5 months ago
#3352 - fix(duckdb)!: Combine aggregate functions with orderby from WITHIN GROUP
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3351 - feat(Vertica): Add Vertica dialect
Pull Request -
State: closed - Opened by Rajasekhar-Vuppala 5 months ago
#3350 - snowflake -> duckdb ordered listagg transpilation error
Issue -
State: closed - Opened by btyuhas 5 months ago
#3349 - [feature request] Support Trino FUNCTION declaration
Issue -
State: closed - Opened by kevinjqliu 5 months ago
- 1 comment
#3348 - fix(tsql): Convert TIMESTAMP to ROWVERSION, transpile both to BINARY
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3347 - feat(clickhouse): Parse window functions in ParameterizedAggFuncs
Pull Request -
State: closed - Opened by VaggelisD 5 months ago
#3346 - Python Executor - ROW_NUMBER() function raises ExecuteError
Issue -
State: closed - Opened by rubytobi 5 months ago
- 1 comment
#3345 - SQL Server Rowversion/Timestamp not parsed correctly
Issue -
State: closed - Opened by aersam 5 months ago
- 1 comment
#3344 - ParseError when handling valid ClickHouse SQL with quantileGK and window functions
Issue -
State: closed - Opened by alesk 5 months ago
#3343 - Feat(prql): add support for AGGREGATE
Pull Request -
State: closed - Opened by fool1280 5 months ago
#3342 - Fix(tsql): only use target table name when generating sp_rename
Pull Request -
State: closed - Opened by georgesittas 5 months ago
#3341 - Feat: parse (a,) as a tuple instead of a paren
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3340 - Feat: allow comments to be attached for identifiers used in definitions
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3339 - Fix!(snowflake): improve transpilability of [TO_]DATE(x)
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3338 - duckdb: non-literal date is no longer cast as date when converted from snowflake
Issue -
State: closed - Opened by tekumara 6 months ago
#3337 - Sqlglot does not preserve Snowflake comments format and merges them into one line
Issue -
State: closed - Opened by baruchoxman 6 months ago
- 1 comment
#3336 - sqlglot cannot recognize/parse column name which starts with a number
Issue -
State: closed - Opened by xinglin-zhao 6 months ago
- 8 comments
#3335 - Conjunction precedence issue: and/or evaluation order
Issue -
State: closed - Opened by anil-panicker 6 months ago
- 1 comment
#3334 - fix ApproxDistinct snowflake transpilation
Pull Request -
State: closed - Opened by ajendrex 6 months ago
- 2 comments
#3333 - fix: allow bigquery udf with resered keyword closes #3332
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3332 - User defined functions with reserved keyword names raise ParseError in BigQuery dialect
Issue -
State: closed - Opened by sean-rose 6 months ago
#3331 - Feat(prql): handle NULL
Pull Request -
State: closed - Opened by fool1280 6 months ago
#3330 - Fix!(bigquery): parse multiple quoted table parts in columns correctly
Pull Request -
State: closed - Opened by georgesittas 6 months ago
- 1 comment
#3329 - feat(clickhouse): Add support for DATE_FORMAT / formatDateTime
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
- 1 comment
#3328 - BigQuery: `*` turns into `6` in PARSE_TIMESTAMP format string
Issue -
State: closed - Opened by schmee-td 6 months ago
- 1 comment
#3327 - feat!: Introduce partition in exp.Table
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3326 - feat(hive): Add 'STORED AS' option in INSERT DIRECTORY
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3325 - feat(Vertica): Add Vertica Dialect
Pull Request -
State: closed - Opened by Rajasekhar-Vuppala 6 months ago
- 3 comments
#3324 - Wrong Convert for 'DATE_FORMAT' between mysql and clickhouse.(TIME_TO_STR)
Issue -
State: closed - Opened by PaienNate 6 months ago
#3323 - Hive's CREATE TABLE SQL comments and storage format in the output of statement are formatted incorrectly.
Issue -
State: closed - Opened by PaienNate 6 months ago
- 3 comments
#3322 - feat!: add comprehensive reserved keywords for presto and redshift
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3321 - Improper parsing Teradata Analytic Functions
Issue -
State: closed - Opened by lorr1 6 months ago
- 2 comments
#3320 - Parsing of insert overwrite directory fails in hive dialect
Issue -
State: closed - Opened by bkyryliuk 6 months ago
#3319 - Hive. Query parsing fails when column is named application for insert overwrite partition
Issue -
State: closed - Opened by bkyryliuk 6 months ago
- 1 comment
#3318 - Unable to resolve columns when using BigQuery's alternate table identifier quoting
Issue -
State: closed - Opened by ravi77o 6 months ago
- 2 comments
#3317 - fix(optimizer)!: Preserve DPipe in simplify_concat
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
- 2 comments
#3316 - feat: allow qualify to also annotate on the fly for unnest support
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3315 - Fix(optimizer): don't simplify parentheses when parent is SubqueryPredicate
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3314 - Fix(redshift): unqualify unnest columns
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3313 - Optimize and remove left joins
Issue -
State: closed - Opened by wesley-too 6 months ago
- 1 comment
#3312 - "NOT BETWEEN" not supported
Issue -
State: closed - Opened by LoganDark 6 months ago
- 5 comments
#3311 - Create view statement generation misses table name if catalog is specified
Issue -
State: closed - Opened by nfx 6 months ago
- 5 comments
#3310 - string escaping is incorrect for mysql
Issue -
State: closed - Opened by cpcloud 6 months ago
- 7 comments
#3309 - Feat(optimizer): improve qualification logic for unnested structs in bigquery
Pull Request -
State: closed - Opened by georgesittas 6 months ago
- 1 comment
#3308 - Refactor: get rid of 1st projection pad for leading comma formatting
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3307 - Fix: transform eliminate_qualify on generated columns
Pull Request -
State: closed - Opened by viplazylmht 6 months ago
- 4 comments
#3306 - Feat(bigquery): handle more extract parts
Pull Request -
State: closed - Opened by maureen-daum 6 months ago
#3305 - Fix: Add postgres transpilation for TIME_TO_UNIX
Pull Request -
State: closed - Opened by crericha 6 months ago
#3304 - Fix!: parse right-hand side of <value> IN (<query>) as a Subquery
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3303 - Feat(teradata): handle transpile of quarter function
Pull Request -
State: closed - Opened by maureen-daum 6 months ago
#3302 - Fix!: cast less aggressively
Pull Request -
State: closed - Opened by georgesittas 6 months ago
- 3 comments
#3301 - feat!: allow unions to be limited directly and stop subquerying since…
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3300 - Solving: 'Union' object has no attribute 'order_by'
Issue -
State: closed - Opened by williaster 6 months ago
- 2 comments
#3299 - Feat(prql): Handle DESC with sort
Pull Request -
State: closed - Opened by fool1280 6 months ago
#3298 - order of logical operation is not interpreted correctly
Issue -
State: closed - Opened by khabiri 6 months ago
- 4 comments
#3297 - Feat(prql): Add support for SORT
Pull Request -
State: closed - Opened by fool1280 6 months ago
#3296 - Teradata datetime functions
Issue -
State: closed - Opened by maureen-daum 6 months ago
- 1 comment
#3295 - Feat: improve transpilation of datetime functions to Teradata
Pull Request -
State: closed - Opened by maureen-daum 6 months ago
- 2 comments
#3294 - Fix(optimizer): propagate recursive CTE source to children scopes early
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3293 - Feat(postgres): add COMMENT ON MATERIALIZED VIEW
Pull Request -
State: closed - Opened by l-vincent-l 6 months ago
#3292 - Fix: make exp.to_column more lenient
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3291 - Feat(prql): Add FILTER
Pull Request -
State: closed - Opened by fool1280 6 months ago
- 2 comments
#3290 - Feat(presto): add support for DISTINCT / ALL after GROUP BY
Pull Request -
State: closed - Opened by georgesittas 6 months ago