Generate REST API endpoints for SQL databases that utilize HTTP Basic or API key authorization.

API endpoints let businesses provide authorized users access to specific data sets but obscure the database details.

For instance, this URL returns a subset of data in JSON format from a proprietary pricing database.

https://valucalc.com/diamondpricesapi.php?apikey=ABC123&cut=ideal&clarity=VVS1&color=D&upper=10&lower=1

The API key and query parameters are sent to a PHP script that connects to the API end point and returns a result.