Hi,
If your version and environment requires escaping, then you need to do
"select geometry, \"building\" as bldg,\"building:levels\" as
bldg_levels,\”height\” as height from multipolygons ... "
It may work also without escaping as
"select geometry, "building" as bldg,"building:levels" as
Hi,
If you enclose something between single quotes in SQL it becomes a string.
SELECT ’building’ -> selects literally the given *string* –building—
However,
SELECT "building" -> selects the *value* of *field* –building-- (or
“identifier” as is it called in SQL)
See for example