Skip to content

Add GETDATE, NOW as alias to parser + allow CURRENT_TIMESTAMP with parenthesis #1979

@paulrutter

Description

@paulrutter

We're in the process of using the AlaSQL parser to validate query syntax in our product.
The AlaSQL parser currently does not recognize the following aliases to CURRENT_TIMESTAMP (see 61date.js).

  • NOW
  • GETDATE

Also, CURRENT_TIMESTAMP is recognized by the parser, while CURRENT_TIMESTAMP() is not.
Do note that all of these functions do work in a query, the parser just cannot properly validate their use.

I'm going to supply a PR to get this fixed, which has one drawback: now, current_timestamp and getdate can no longer be used as column aliases, as they're now reserved keywords.

Let me know what you think @mathiasrw.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions