Hacker GitHub

← All repos

sripathikrishnan/jinjasql

View on GitHub ↗ ★ 843 Python

Template Language for SQL with Automatic Bind Parameter Extraction

12 mentions on Hacker News by 4 people: 4 stories, 8 comments · first 2016-11-03 · latest 2020-08-14

Mentions per year 12 mentions · busiest year 2016 (6)
20082026
AllStoriesComments NewestTopOldest
  1. Take a look at JinjaSQL ( https://github.com/hashedin/jinjasql ). Supports conditional where clauses as well as in statements. It uses Jinja templates, so you get a complete template language to create the queries.
    comment by ksri · 2020-08-14 · in Simple SQL in Python
  2. …gives you the power to use JINJA inside the SQL query. For more details, check out JinjaSQL here - https://github.com/hashedin/jinjasql With JinjaSQL in the scene, you can access real-time variables related to - A logged-in user - Web…
    comment by swapnil95 · 2017-05-12 · in Show HN: SQueaLy – Fast track analytics for business
  3. I posted elsewhere on this thread, but take a look at JinjaSQL - https://github.com/hashedin/jinjasql . Let's you generate SQL from a string template without worrying about SQL injection.
    comment by ksri · 2017-02-21 · in Django 1.11 beta 1 released
  4. Take a look at JinjaSQL - https://github.com/hashedin/jinjasql . Beyond a certain complexity, Django ORM gets in the way. Constructing SQL by hand is painful and can lead to SQL injection. And that's where JinjaSQL shines. You write your…
    comment by ksri · 2017-02-21 · in Django 1.11 beta 1 released
  5. In clauses are blown up. I have now added that to the documentation - see https://github.com/hashedin/jinjasql#handling-in-clauses Skipping in clauses altogether - for now, you can handle that using an if condition.
    comment by ksri · 2016-11-09 · in Show HN: JinjaSQL – Generate SQL Queries using a Jinja Template
  6. Doesn’t seem to be – https://github.com/hashedin/jinjasql/blob/master/setup.py#L5... – so I don’t know why the README implies that.
    comment by minitech · 2016-11-04 · in Show HN: JinjaSQL – Generate SQL Queries using a Jinja Template
  7. …JinjaSQL is mostly meant for dynamic select statements that an ORM cannot handle as well. [1] https://github.com/hashedin/jinjasql#when-to-use-jinjasql
    comment by marcloney · 2016-11-04 · in Show HN: JinjaSQL – Generate SQL Queries using a Jinja Template
  8. I'd love to get HN feedback on a library I wrote to make SQL more manageable - https://github.com/hashedin/jinjasql . The library is built on the Jinja template engine. You can create macros, functions and other reusable sql fragments, and…
    comment by ksri · 2016-11-03 · in Writing more legible SQL