Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Consider using abstraction layer for SQL query generation #7

Open
epatters opened this issue Jul 28, 2020 · 3 comments
Open

Consider using abstraction layer for SQL query generation #7

epatters opened this issue Jul 28, 2020 · 3 comments
Labels
question Further information is requested

Comments

@epatters
Copy link
Member

epatters commented Jul 28, 2020

I tend to be leery about generating code by string manipulation. We should consider using a DSL/AST for generating SQL queries. I just found out about Octo.jl, which looks nice.

@epatters epatters added the question Further information is requested label Jul 28, 2020
@bosonbaas
Copy link
Member

Yeah, the string manip to generate SQL queries is pretty hacky. I'll look into getting some kind of DSL in there to generate queries, and Octo.jl looks really nice for that, thanks!

@epatters
Copy link
Member Author

On the Julia Zulip, I found out about the new package FunSQL.jl, which looks like it provides a SQL AST and pretty-printer.

@jpfairbanks
Copy link
Member

I've talked with the author of that package a few times and I think we are aligned in the goals of making higher level querying interfaces. So it makes sense to try and use that package.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

3 participants