Skip to content

SQL query field can't begin by a comment #1860

@CharlesNepote

Description

@CharlesNepote

image

SQL comments are very useful to explain the meaning of the query. It's currently impossible to put it at the beginning of the field as seen on the screen capture: it leads to an error: Statement must be a SELECT.

It would be great to make it possible because:

  • as the request is the title of the page:
    • it eases the search with search engines
    • it eases the search in the browsers' url field
  • it acts as a kind of title: the global meaning of the query is immediately understandable
  • some tools, such as Slack, are shortening long URLs and displaying the beginning of the URLs (eg. https://example.org/products?sql=select+%28length%28data_quality_errors_ta[...]+%21%3D+%22%22+group+by+NB_of_issues+order+by+NB_of_issues+desc+limit+200)

Beginning a query with a comment is possible with SQLite.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions