AWS AppSync GraphQL enhances Amazon Aurora PostgreSQL and MySQL support with new resolver utilities

AWS AppSync GraphQL is a fully managed service that helps developers create flexible GraphQL APIs that connect to data, events, and AI models. AppSync GraphQL can connect applications to various data sources, including Amazon Aurora PostgreSQL and Amazon Aurora MySQL. AppSync GraphQL now offers enhanced utilities for Amazon RDS in JavaScript resolvers. This update expands existing capabilities and introduces new aggregate functions.

The enhancement adds new functionality to the select utility and makes it easier to build safe and accurate SQL select statements. Developers can now use a variety of join types, including inner, left, right, and full outer joins, as well as their natural counterparts. New aggregate helpers, such as min, max, sum, avg, and count (including distinct variants) makes it easier to build queries that use the “group by” and “having” statement. The select utility now supports aliases for tables and columns, and allows developers to mix in the sql tagged template to write custom where and join conditions.

These enhancements are available in all AWS Regions where AWS AppSync is offered.

To learn more about this built-in module, visit the AWS AppSync documentation. You can start using these enhancements today by updating your resolver code in the AWS AppSync console.