menu
techminis

A naukri.com initiative

google-web-stories
Home

>

Programming News

>

gq-to-sql ...
source image

Dev

1w

read

242

img
dot

Image Credit: Dev

gq-to-sql v0.2.0 — Grouping, Joins, and PostgreSQL Support

  • gq-to-sql v0.2.0 has been released with Grouping, Joins, and PostgreSQL Support.
  • The utility converts Microsoft Graph-style query strings into parameterized SQL for various applications.
  • New features in v0.2.0 include $expand=table($select=...) with JOIN support and $apply=groupby(..., aggregate(...)).
  • Users can now combine $apply and $filter in a single query and select different SQL dialects like mysql or postgres.
  • Improved alias mapping and schema-based JOINs enhance the utility's functionality.
  • An example code snippet demonstrates building SQL queries based on a query string for users and roles.
  • The utility output provides a SQL query with parameters and offers flexibility in placeholder style selection.
  • Users can install gq-to-sql using npm with the command npm install gq-to-sql.
  • The source code is available on GitHub at github.com/masem1899/graphql-to-sql.
  • Package details can be found on npmjs.com at npmjs.com/package/gq-to-sql.
  • For more information, users can visit the utility's website at https://masem.at.

Read Full Article

like

14 Likes

For uninterrupted reading, download the app