Would you be able to recommend a simple open-source library/tool to run in Linux, which would serve a REST-like API basically serving the content of SQL databases (in Postgres) over HTTP with friendly URLs? Python preferred, but not mandatory.
e.g. if you had a database with two tables:
employees (id, name, city, dep_id) departments (id, name)
I would like to easily send HTTP requests like:
GET http://$HOST/employees?city=Paris GET http://$HOST/employees?dep_id=4&city=Berlin,Paris GET http://$HOST/departments?name=Legal,Finance
etc. I am flexible with whatever syntax needs to be used for URLs. But the goal is to avoid manual work of mapping these tables through ORM, then mapping that to URLs, etc. Ideally no programming needed at all (but allowed if I wanted to add a custom output format, etc.)
Also I understand this tool could only offer
SELECT with only limited