Question: Is there an open-source tool that can automatically generate API endpoints from SQL queries for my frontend application?

For an open-source tool to automatically generate API endpoints from SQL queries, you might also want to check out Latitude. Latitude is an embedded analytics framework that converts SQL queries into API endpoints. It supports a variety of databases and local CSV files and comes with native frontend components for React, with Svelte and Vue support on the way. The framework also comes with a built-in cache layer for fast response times and is designed with security in mind, making it a good option for generating and managing API endpoints.

Another alternative is Supabase, an open-source Firebase alternative that lets you build production-ready apps with a Postgres database, instant APIs and real-time subscriptions. It supports frameworks like Next.js, Svelte and Flutter, and offers features like user authentication, edge functions and real-time data synchronization. Supabase offers unlimited API requests in its free tier, so it can be a good option if you're looking for a low-cost way to generate and manage APIs from SQL queries.

Neurelo is another option. This cloud API platform converts databases into APIs, supporting PostgreSQL, MongoDB and MySQL. It offers immediate auto-generated REST and GraphQL data APIs and includes features like Schema as Code and deep query observability. Neurelo offers a unified experience for building, running and scaling applications, which can be helpful if you need to manage and generate API endpoints efficiently.