We are working on a new project called StackQL, which makes it easier for developers to query and manipulate data from cloud and SaaS providers using SQL grammar and semantics.<p>StackQL is an API client built on top of provider OpenAPI specs with future support for GraphQL and gRPC/proto defs.<p>Some links are here:<p><a href="https://github.com/stackql/stackql">https://github.com/stackql/stackql</a>
<a href="https://github.com/stackql/stackql-provider-registry">https://github.com/stackql/stackql-provider-registry</a>
<a href="https://registry.stackql.io/" rel="nofollow">https://registry.stackql.io/</a>
<a href="https://stackql.io/docs" rel="nofollow">https://stackql.io/docs</a>
<a href="https://stackql.io/blog/" rel="nofollow">https://stackql.io/blog/</a><p>StackQL can be used to query cloud resources (including cross-provider JOIN queries) as well as provisioning and de-provisioning (using INSERT and DELETE) and lifecycle methods (like starting or stopping VM instances - using EXEC).<p>There is a client mode and a server mode, which serves over the Postgres wire protocol; this is not a Postgres server - nor does it require one. It is not FDW based; we implement our own parser, planner, and executor. It is a self-contained dev tool that could be used in GitHub actions, standalone, or with a visualization solution (such as Tableau, Superset etc.).<p>We seek feedback and suggestions for features and improvements (and contributors).<p>Thanks for your help!