AlgebraicRelations.jl icon indicating copy to clipboard operation
AlgebraicRelations.jl copied to clipboard

Consider using abstraction layer for SQL query generation

Open epatters opened this issue 5 years ago • 3 comments

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 avatar Jul 28 '20 06:07 epatters

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!

bosonbaas avatar Aug 03 '20 15:08 bosonbaas

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

epatters avatar Jun 18 '21 22:06 epatters

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.

jpfairbanks avatar Jun 19 '21 19:06 jpfairbanks