Skip to content

Add support for FIRST, LAST aggregation parsing. #877

Closed
@mustafasrepo

Description

@mustafasrepo

When we run the query below currently, sqlparser cannot parse it

SELECT FIRST(x ORDER BY x) AS a FROM T

similarly, it cannot parse corresponding query with LAST either.
although it is not a standard feature, this function is very common and helpful. I would like to have support for these functions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions