Closed Sevenannn closed 5 days ago
N/A
When unparsing CharacterLengthFunc scalar function to DuckDB & SQLite syntax SQL query, the CharacterLengthFunc scalar function need to be unparsed to length, since length is the equivalence of CharacterLengthFunc in DuckDB & SQLite.
CharacterLengthFunc
length
DuckDB length() SQLite length()
DuckDBDialect
Dialect
character_length_style
CharacterLengthStyle
character_length_to_sql
character_length
Yes
No
🚀
Which issue does this PR close?
N/A
Rationale for this change
When unparsing
CharacterLengthFunc
scalar function to DuckDB & SQLite syntax SQL query, theCharacterLengthFunc
scalar function need to be unparsed tolength
, sincelength
is the equivalence ofCharacterLengthFunc
in DuckDB & SQLite.DuckDB length() SQLite length()
What changes are included in this PR?
DuckDBDialect
, which implements theDialect
traitcharacter_length_style
forDialect
trait for determining theCharacterLengthStyle
to use for a dialectcharacter_length_to_sql
, which unparses theCharacterLengthFunc
tolength
orcharacter_length
based onCharacterLengthStyle
Are these changes tested?
Yes
Are there any user-facing changes?
No