Looking forward to seeing this!
matt-savvy
Schultzer
Yes, I’m planning to push an example repo with a new phoenix application with phx.gen.auth where all database interactions is done by SQL beside migrations.
SQL 0.5 does ship with create and drop database mix task, although I’m waiting till after I have implemented decoder/encoder specialization to focus on some of the table stakes features and documentations.
Most of this journey has been about proving that we can do better, so obviously differentiators has been the focus of work as those was the new ideas and very hard problems. I realize now why nobody have built something like this before. Although without Elixir and BEAM this would not have been possible.
1
Schultzer
krasenyp
Thank you for this! I’m still wondering if composing queries is possible. Can I iteratively build a query?
0
Schultzer
Yes, the readme shows how to pipe ~SQL, that could also be a function that takes a ~SQL and pipe it into another, you can still end up creating invalid SQL as validation is not as strong as it could be. But as we’ve an AST then it’s straightforward to add validation and any errors.
I have a couple of tests in the suite, I could do a better job at documenting this and the library in general.
PRs to improve documentation are highly appreciated.
2
LostKobrakai
Is there any way in sql to make non parameterized parts of a query dynamic – like a dynamic table or column name? With an uppercase sigil it can’t be interpolated into the query.
0
Schultzer
There is currently no documented public API for this as I have been awaiting user request for this, there is an undocumented SQL.parse function that is used internally for this exact reason, it’s undocumented because you could potentially shot yourself in the foot and its slower then the sigil.
It’s targeted for a major refactor in the upcoming release as it’s being used more then ever due to encoder/decoder specialization.
In terms of safety what is your expectation?
0
LostKobrakai
My intention here is mostly to use it as a query builder, given I’m using sqlite in that project. This is an ETL type job with an sqlite db as the output, so very dynamic, but I want to be able to read the code and not be hindered by tons of string concatinations to build up the queries.
0
Schultzer
Sounds like you’re looking for something different then the parse function.
I’ve had thoughts about supporting inlining in the sigil but with a different syntax then {{}}. But never been confident that it was a good idea to mix that.
There is also the potential to use modifiers to flag if parameters should be inlined or not.
I think it would be helpful to see an ideal example of how you imagine the sigil to work for this use case.
0
krasenyp
Enabling dynamic column names sounds more trouble than it’s worth. I guess conditional logic and composition in the code is better than built-in interpolation in this case.
1