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

#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

#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

#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

#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

#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

#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

#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

#3343 - Feat(prql): add support for AGGREGATE

Pull Request - State: closed - Opened by fool1280 5 months ago

#3341 - Feat: parse (a,) as a tuple instead of a paren

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

#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

#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

#3321 - Improper parsing Teradata Analytic Functions

Issue - State: closed - Opened by lorr1 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

#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

#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

#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

#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

#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