Skip to content
This repository was archived by the owner on Apr 18, 2026. It is now read-only.
This repository was archived by the owner on Apr 18, 2026. It is now read-only.

Referral by column names in Sheets QUERY #2971

@brew-guy

Description

@brew-guy

If your feature has not been requested, please provide all of the following:

A short description of the request:
The Sheets QUERY documentation states that the query string should be written in the Google Visualization API Query Language. The API Query Language in turn indicates that column names can be used straight up in queries like "select name where salary > 700".

It doesn't seem to hold true when used with the QUERY function, though, as any attempt (e.g. "select name where 'salary' > 700") will result in a NO_COLUMN error in Sheets.

What is the purpose of this new feature?
It would make the querying in Sheets more legible if you rely on keeping your queries resilient because the current workarounds require string concatenation with match() lookups and what not.

What existing APIs would this affect?
Sheets

What existing data does this use?
None

Please provide any additional information below.
None

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