calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Hait (Jira)" <>
Subject [jira] [Created] (CALCITE-4035) Adapter for REST interface with query or path parameters
Date Sun, 31 May 2020 15:52:00 GMT
David Hait created CALCITE-4035:

             Summary: Adapter for REST interface with query or path parameters
                 Key: CALCITE-4035
             Project: Calcite
          Issue Type: New Feature
            Reporter: David Hait

A typical microservice with a REST interface will be queryable by an HTTP GET with query parameters
or path parameters, and return JSON.  It would be useful to have an adapter that allows access
to this sort of interface.  One use case would be to allow a join between a database table
and a table which represents the interface.  SQL "where" items could be mapped to specific
query parameters or path parameters on the web API.

So, for example,

{{    SELECT * from service.MyEndpoint where id=123;}}

could get translated into

{{  GET http:/service/MyEndpoint/123}}

or alternatively

{{  GET [http://service/MyEndpoint?id=123]}}

 The mapping between SQL terms and URL path would be specified in a model file.


This message was sent by Atlassian Jira

View raw message