TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

JinjaSQL – Templating Language to Generate SQL Statements

7 pointsby ksriover 8 years ago

1 comment

ksriover 8 years ago
While ORMs solve 80% of the needs, you still need the power and flexibility of SQL for those 20% of the needs. Anytime you need reporting, complex joins or aggregation - SQL is a natural choice.<p>But generating dynamic SQL by hand is error prone and has lot of repetition, especially when your query grows big.<p>JinjaSQL gives you the flexibility of a template language (Jinja), without having to manually track your bind parameters. It&#x27;s not a replacement for an ORM, but is meant for those 10-20% use cases that require the power of SQL.