Is there a "template engine" in Python to generate SQL?

Question

How do I generate SQL code for a SQLite3 database somehow dynamically with something like a template engine? I'm new to this and I'm using jinja2 to generate HTML. Could jinja2 possibly be used for such a purpose as well, if so, is that a good idea? I would like my program to save all the data (attribute values of instances of various classes) before it stops running.

You're looking for ORMs - Object Relational Mappers. SO isn't the place for software recommendations however. — Colonel Thirty Two
– Colonel Thirty Two, Commented Dec 6, 2015 at 23:33
Also it doesn't really sound like you want a database; surely serializing to JSON or another format (ex. using Python's json module) would be easier? — Colonel Thirty Two
– Colonel Thirty Two, Commented Dec 7, 2015 at 0:42

zyd · Accepted Answer · 2018-03-06 05:37:04Z

3

check out https://pypi.python.org/pypi/jinjasql/0.1.6 it seems to basically just apply jinja2 to SQL templates. I haven't played with it much yet but was just asking the same question and came upon this.

answered Mar 6, 2018 at 5:37

zyd

9351 gold badge8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ben Rudolph Over a year ago

Note there is a very dangerous infinite loop bug in this library: github.com/hashedin/jinjasql/pull/17

Sripathi Krishnan Over a year ago

For posterity, the infinite loop bug has been resolved, thanks @BenRudolph!

Micah Elliott · Accepted Answer · 2024-05-24 12:59:15Z

0

PugSQL is described as: a simple Python interface for using parameterized SQL, in files, with any SQLAlchemy-supported database.

It is a template engine in that parameters are passed into SQL, from which python functions are created. It is a powerful idea/approach borrowed from HugSQL and YesQL (Clojure implementations).

answered May 24, 2024 at 12:59

Micah Elliott

10.4k5 gold badges57 silver badges56 bronze badges

Collectives™ on Stack Overflow

Is there a "template engine" in Python to generate SQL?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related