This provides syntax highlighting and auto-completion of SQL in VS Code.
Would it be possible to have a section in a .jl file that VS Code treats as SQL
(for syntax highlight and autocompletion) ? Then convert the result to a Julia DataFrame.
Something like
@SQL_Block my_connection_string
select * from my_table
end |> DataFrame
Typically, you’d use a string macro for this, which already gives you the correct syntax highlighting:
I’m not sure if you get the auto completions provided by the SQL Server extension, but I highly doubt it. This is not something we can implement on our end.