GraphSQL

GraphQL (https://graphql.org/learn/) is a modern query language that allows you to send JSON-like query structure to a database, and get back data in the same structure. It allows you to query multiple tables with multiple options in just 1 API call.

With GraphSQL you can add GraphQL support straight into Salesforce, without needing to write any code, with a custom REST API endpoint.

Using GraphQL not only allows you to query multiple different objects and relationships, but lets you do it in a single call, meaning you only use up 1 API call, rather than multiple calls through the REST API. You can specify filters and order criteria to get exactly the data you need.

You can also send Mutations, which allow you to create or update records and related data in one call.

With the GraphQL playground you can test out your GraphQL queries and see the data you'll get back, as well as the queries that were run as part of your API call.