3 ms·
My dream is to write actual SQL in the middle of my code, as a valid syntax and first-class construct. As I said, that's not really a realistic goal. Do you ha
by dgellow 6y ago
My dream is to write actual SQL in the middle of my code, as a valid syntax and first-class construct. As I said, that's not really a realistic goal.
Do you have some examples of SQLAlchemy core layer you're talking about, just to have an idea of what you have in mind?
- squaresmile 6y agoI couldn't find exactly an only Core example that you are looking for in the examples folder [0] so here is a more complicated tutorial query [1] and here's how I use Core in my project [2] (mostly short select statements so not really a comprehensive demonstration of SQLAlchemy Core's capabilities). [0] https://github.com/sqlalchemy/sqlalchemy/tree/master/examples https://github.com/sqlalchemy/sqlalchemy/tree/master/example... [1] https://docs.sqlalchemy.org/en/14/core/tutorial.html#common-table-expressions-cte https://docs.sqlalchemy.org/en/14/core/tutorial.html#common-... [2] https://github.com/atlasacademy/fgo-game-data-api/tree/master/app/db/helpers https://github.com/atlasacademy/fgo-game-data-api/tree/maste...
- dgellow 6y agoThank you :)
- lelanthran 6y ago> My dream is to write actual SQL in the middle of my code, as a valid syntax and first-class construct. As I said, that's not really a realistic goal. Sure, it is. See how regexes in some languages are first class datatypes, so you can have a regex literal in your code (with backreferences too, I believe). There is no good reason that SQL statements can't also be a datatype, with SQL literals in the code like the way regexes do. I'm imagining something like this: sql_t stmt = /SELECT #1, #2 FROM #3, #4 WHERE #3.#1 = #4.#2/; sql_res_t res_cursor = sql_exec (stmt, t1_col1, t2_col2, T1, T2); The stmt above is not a string, hence is part of the AST and can be checked at compile time. The execution might be a problem (returned columns have to be checked too).