Skip to content

[ENH] Add support for CONCAT function #252

@ayushdg

Description

@ayushdg

Is your feature request related to a problem? Please describe.
Dask-sql supports concatenating columns via the || operator but does not support the CONCAT method.

Describe the solution you'd like
Supporting CONCAT as follows:
SELECT CONCAT('John', ', ', 'Doe')

Describe alternatives you've considered
Workaround to this is using the || operator
SELECT 'John' || ', ' || 'Doe'

Additional context
While checking this feature I also came across CONCAT_WS which is a part of the postgresql featureset but this doesn't get parsed by calcite.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions