How to make SQL autocompletion work with custom table apply

Hi,

I’m working on an SQL editor and I’m struggling to make the SQL autocomplete suggest column names when using a schema in combination with the “apply” feature of the tables.

Here is a minimal sandbox for the examples : react-codemirror-example (table completion) - CodeSandbox

When the query is the following, the autocomplete does not suggest any results :
select t.<cursor position> from ${TABLE["1234"]} t

When the query is the following, the autocomplete suggests the “customer” table when I expect it to suggest the columns from the table :
select ${TABLE["1234"]}.<cursor position>

Is this the expected behaviour ? Thanks !

1 Like