Query editor errors when referencing previous cells

[AbelVM]

Looks like you're not allowed to use aliases. This code fails

SELECT
   b.the_geom
FROM 
    {{myquery}} as b

And when you want to reference more than one cell with same columns and need to specify the table name, also fails

SELECT
   {{myquery2}}.cartodb_id
   {{myquery1}}.the_geom
FROM 
    {{myquery_1}} ,
    {{myquery_2}}
WHERE ...

[AbelVM]

Wrapping the cell reference within parentheses doesnt even work:

SELECT
   b.the_geom
FROM 
    ({{myquery}}) b

[alrocar]

Looks like a limitation in one of the core functions -> https://github.com/HVF/franchise/blob/master/src/db/generic.js#L98

Should we open a ticket on the master repo?

[AbelVM]

sure!

[AbelVM]

HVF#56