search

AlgebraicJulia / AlgebraicRelations.jl

Relational Algebra, now with more algebra!
https://www.algebraicjulia.org
MIT License
47 stars 3 forks source link

Consider using abstraction layer for SQL query generation #7

Open epatters opened 4 years ago

epatters commented 4 years ago

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.

bosonbaas commented 4 years ago

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 commented 3 years ago

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 commented 3 years ago

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.