Multiline SQL statements

[bryaan]

Is it possible to have multiline sql statements?

        df = Repo.query([
            SELECT (e.name, e.age) FROM MyTable 
            WHERE e.data_source==dataSource 
        ])

[wookay]

that code throws ArgumentError like.

ERROR: LoadError: ArgumentError: number of columns of each array must match (got (4, 2))

because you should follow the array syntax of julia,

julia> [
        1 1 1 1
        1 1
       ]
ERROR: ArgumentError: argument count does not match specified shape (expected 8, got 6)

so you could make (2,3) array

df = Repo.query([
    SELECT (e.name, e.age)
    FROM MyTable
    WHERE e.data_source==dataSource
])

[bryaan]

Looks like its due to the julia autoformatter in VSCode. Will have to dig in to file an issue there.