jinjasql
jinjasql copied to clipboard
Template Language for SQL with Automatic Bind Parameter Extraction
After run a test suite in my project, I got the following warning: ``` DeprecationWarning: The 'autoescape' extension is deprecated and will be removed in Jinja 3.1. This is built...
When using sqlachemy, bind parameters named with a '#' raise errors. Apparently this is due to sqlalchemy using '#' as a separator. Instead of expecting a bind parameter named 'bind#0_{n}',...
"Invalid parameter 1: Parameter index is out of range" when SQL contains comments (-- comment style)
Hello! After I've upgraded to version 0.1.8, now my ETL job is failing with the traceback below: ``` Traceback (most recent call last): File "C:\Users\\apps\python38\envs\prefect_dev\lib\site-packages\pandas\io\sql.py", line 1697, in execute cur.execute(*args,...
I would like to use this with https://github.com/moban to convert a template containing a few custom queries with preset data into a db-specific rendered file, each enclosed in a method...
I'm trying to exec this query in Superset-SQLab ```sql SELECT {{gender_enum(users.gender)}} as gender from users; ``` The gender_enum is defined like this ```python lambda x: ['Femenino', 'Masculino', 'Otro', 'Prefiere no...
This PR adds an `identifier` filter to escape SQL identifiers, like table and field names. As mentioned in #32, this would allow for safe and dynamic insertion of table and...
Hi there, Firstly thank you for a really useful package! I've tried a number of queries and they all worked until I used a query that uses LIKE statements in...
- `markupsafe` made a breaking change but `Jinja2` does not pin to a safe version. Pinned `markupsafe` to a safe version here instead. - Removed EOL-ed Python versions (3.5 and...
is this project EOL? don't see much activity, is there any alternative anyone recommends?
AttributeError: module 'jinja2.ext' has no attribute 'autoescape' due to following reason: Jinja2 3.1, WithExtension and AutoEscapeExtension are built-in now thus are no longer needed. Removed addition of autoescape extension from...