How to execute raw SQL in Flask-SQLAlchemy app

Become part of the top 3% of the developers by applying to Toptal https://topt.al/25cXVn

--

Music by Eric Matyas
https://www.soundimage.org
Track title: Dreaming in Puzzles

--

Chapters
00:00 Question
00:37 Accepted answer (Score 408)
01:05 Answer 2 (Score 271)
03:19 Answer 3 (Score 69)
04:02 Answer 4 (Score 67)
04:28 Thank you

--

Full question
https://stackoverflow.com/questions/17972020/how-to-execute-raw-sql-in-flask-sqlalchemy-app

Accepted answer links:
[deprecated in SQLAlchemy 2.0]: https://docs.sqlalchemy.org/en/14/core/connections.html#connectionless-execution-implicit-execution

Answer 2 links:
[managed by a transaction]: https://docs.sqlalchemy.org/en/latest/orm/session_transaction.html
[engine]: https://stackoverflow.com/a/17987782/1394393
[connection]: https://stackoverflow.com/a/18808942/1394393
[parameterized queries]: https://stackoverflow.com/a/4712113/1394393
[an iterable]: https://docs.sqlalchemy.org/en/latest/core/connections.html?highligh
[RowProxy]: https://docs.sqlalchemy.org/en/latest/core/connections.html?highligh

Answer 3 links:
[SQL Expression Language Tutorial - Using Text]: http://docs.sqlalchemy.org/en/latest/core/tutorial.html#using-textual-sql

Answer 4 links:
[here]: https://docs.sqlalchemy.org/en/13/orm/tutorial.html#using-textual-sql

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/licensing

--

Tags
#python #sql #sqlalchemy #flask #flasksqlalchemy

#avk47