Automatic Query Endpoints: Creating APIs from SQL Queries

ClickHouse has introduced Automatic Query Endpoints, a feature that enables developers to create APIs directly from saved SQL queries in the ClickHouse Cloud Console with just a few clicks. This feature aims to provide an easy way for front-end and microservices to consume data returned by queries. The new tooling is part of ClickHouse's efforts to improve the developer experience around programmatic data consumption, following the launch of ClickPipes last year. Query-based API endpoints address two key challenges: wrangling language clients/drivers and authentication and access control. The feature is currently in Beta and will be further enhanced with support for JWT authentication and a streaming API.