Making GraphQL Magic with Sqlmancer 🧙🔮✨

Today I'm excited to announce the beta release of Sqlmancer! Sqlmancer is a Node.js library that empowers you to effortlessly and efficiently translate GraphQL queries into SQL statements. This article will walk through setting up a project with Sqlmancer and showcase a few of its many 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.
• Performance. Avoid the N+1 problem by building a single SQL query to fetch all necessary data, regardless of query depth.
• 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.
• Mutations made easy. Create, update and delete records, with or without transactions, using a simple, fluent API.
• Views and CTEs. Take advantage of existing views in your database or 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.

Continue reading on DEV

Making GraphQL Magic with Sqlmancer 🧙🔮✨

Making GraphQL Magic with Sqlmancer 🧙🔮✨

Sqlmancer is a Node.js library that empowers you to effortlessly and efficiently translate GraphQL queries into SQL statements.