Support for other statements

[lucap-irion]

Hi,
Do you have plans to support statements other than SELECT?

Are eventually PR welcome?

Thanks,
Luca

[zfarrell]

Apologies for the last message, I mixed up repos!

PRs are absolutely welcome! Is there anything in particular you're interested in adding support for?

[lucap-irion]

Hi, no problem :)
We are trying to integrate DuckDB into our ecosystem, and we need a robust solution that lets us discover dependencies for every statement a data engineer can write. Our prototype is currently based on Polyglot, which seems more complete for now and has a useful Rust C API, but it does not feel as “native” as your solution.
I do not have a finalized list of statements, but I think CTAS, COPY, CRUD operations, and MERGE would be a very good starting point.

[zfarrell]

Thanks for the context @lucap-irion ! I'm absolutely open to adding these (/all) statements. It might take me some time to get to this, but would also happily accept a pr if you're open to it.

Another thing you might consider for your use case is DataFusion. I know there are others that use DataFusion for this exact use case. Since you're already using rust, it might be a great fit.

That said, happy to help make parser tools work for your use case, too!

[lucap-irion]

Wow, great!
I don’t know if I can work on it right now, but I’m not in any great hurry.
For now, while we wait for your changes, Polyglot can be enough.

ty!