search

observablehq / framework

A static site generator for data apps, dashboards, reports, and more. Observable Framework combines JavaScript on the front-end for interactive graphics with any language on the back-end for data analysis.
https://observablehq.com/framework/
ISC License
2.56k stars 122 forks source link

Dynamic column names in SQL query #1819

Closed MoritzStefaner closed 1 week ago

MoritzStefaner commented 1 week ago

Hi,

the following query works fine:

SELECT value FROM ccvi WHERE year=${year} AND quarter=${quarter}

However

SELECT ${property} FROM ccvi WHERE year=${year} AND quarter=${quarter}

does not seem to work. Is this a known limitation or a bug?

Thanks for looking into this.