Sqlmancer
Conjure SQL from your GraphQL queries
🧙
🔮
✨
⚠️ This project is currently on hiatus. I am hoping to resume working on Sqlmancer once I have some more free time. Feel free to submit new issues for feature requests or bug reports, although I may not address them immediately.
Sqlmancer is a Node.js library for integrating SQL with GraphQL. It empowers you to effortlessly and efficiently translate GraphQL queries into SQL statements.
How it works
Sqlmancer generates a fluent, type-safe database client from your schema based on metadata you provide through schema directives. With Sqlmancer, your resolver can be as simple as this:
function resolve (root, args, ctx, info) {
return Film.findMany().resolveInfo(info).execute();
}
while still allowing complex queries like this:
Show query
query FilmQuery {
films(
where: {
or: [
{ budget: { greaterThanOrEqual: 50000000 } },
{ language: { name: { in: ["Spanish", "French"] } } },
]
actors: { count: { lessThan: 50 } },
},
orderBy: [{
actors: { avg: { popularity: DESC } }
}],
limit: 100
) {
id
title
actors(
orderBy: [{
popularity: DESC
}],
limit: 10
) {
id
firstName
lastName
films(
orderBy: [{
films: { min: { budget: ASC } }
}]
limit: 5
) {
id
title
}
}
}
}
Features
- Multiple dialect support. Sqlmancer supports Postgres, MySQL, MariaDB and SQLite, enabling you to incorporate it into existing projects regardless of what flavor of SQL you're using.
- Robust filtering and sorting. Add complex filtering and sorting to your queries, including filtering using logical operators and filtering and sorting by fields and aggregate fields of related models.
- Arbitrarily deep nesting. Define one-to-one, one-to-many and many-to-many relationships between models. Related models can be filtered, sorted and paginated just like root-level fields.
- Performance. Avoid the N+1 problem by building a single SQL query to fetch all necessary data, regardless of query depth.
- Mutations made easy. Create, update and delete records, with or without transactions, using a simple, fluent API. Easily provide WHERE, ORDER BY and LIMIT clauses to your queries when updating and deleting records.
- Views and CTEs. Take advantage of existing views in your database and create inline ones using common table expressions.
- Custom scalars. Use the scalars that make sense for your schema.
- Abstract types. Utilize unions and interfaces in your schema using views or single table inheritance.
Design goals
- Annotation over transformation. Sqlmancer aims to be as aspect-oriented as possible, with directives being used mostly to annotate your schema rather than outright change its behavior.
- Limited type-generation. Sqlmancer offers a number of convenient directives to generate arguments or types, but these directives are never required for Sqlmancer to work its magic. What types are exposed in the schema is ultimately left up to you.
- More than just CRUD. Sqlmancer empowers you to create the queries and mutations that are right for your schema.
- Flexible and unopinionated. Sqlmancer enabled you to easily add features like authorization, tracing, cost analysis and depth limits using existing libraries without paying for a "pro" version.
See the official documentation for API reference, guides and more.
Community
If you found a bug, have a feature request or want to contribute to the project, please open an issue. If you need help or have a question, you can ask on Stack Overflow or come chat with us on Discord!
Contributors
Thanks goes to these wonderful people (emoji key):
 Daniel Rearden |
 Pavel Ravits |
 Tadej Stanic |
 Tristan Siegel |
This project follows the all-contributors specification. Contributions of any kind welcome!
6 Nov 15, 2022
747 Dec 28, 2022
49 Jan 1, 2023
10 Oct 16, 2022
10 Aug 28, 2022
67 Sep 30, 2022
3.2k Jan 3, 2023
33 Dec 19, 2022
1 Jan 8, 2022
27.3k Jan 4, 2023
30.1k Jan 3, 2023
6.8k Jan 3, 2023
6.9k Jan 5, 2023
6.1k Jan 9, 2023
28k Jan 2, 2023
5.4k Jan 4, 2023
2.1k Jan 4, 2023
478 Dec 21, 2022
3 Nov 25, 2021