Oliver Mannion
Oliver Mannion
I've added support for parsing `CREATE SEQUENCE` to sqlglot [here](https://github.com/tobymao/sqlglot/pull/3072), if that helps?
solving this will require new duckdb logical types that work as json. json [itself is a logical type of varchar](https://github.com/duckdb/duckdb/blob/dae3b286b04cb2e89cf624e6104c94afaf5b7468/extension/json/include/json_common.hpp#L92), so these new types should map to varchar. The new...
I think we could transform simple MERGE statements to INSERT ON CONFLICT, ie: when the clause is `when not matched` or `when matched` like in your example. But if there...
@sbouclier do you have an example of the MERGE statements you'd like support for?
Appreciate the support @nolanbconaway! Thanks must go to @jsibbison-square for pushing forward MERGE support. Do let us know if you find any edge cases that aren't supported.
`%%sql` works fine.
No longer an issue when using: ``` %config SqlMagic.named_parameters="disabled" ```
Thanks for looking into this! For me they are all equally important. Having no warnings from prefect is ideal so I can focus on the warnings in my flow code.
Thanks for starting this! It's a tricky feature. I hope you don't mind but I've pushed 40ada94 as a test case to cover. It comes from the [Snowflake MERGE docs](https://docs.snowflake.com/en/sql-reference/sql/merge#:~:text=Perform%20a-,basic%20merge,-with%20a%20mix)....
How did you go @jsibbison-square? Do you need any help with this?