Attached is a small utility which help in getting the SQL keywords used by PostgreSQL and pl/pgsql.
Note that, for pgsql code path is required as keywords are not available in any docs. So, the code paths may need to change with new release of PostgreSQL. For PostgrSQL keywords, it will fetch from the website.
Kindly review.
A few thoughts:
- The code isn't PEP-8 compliant.
- Do we really need to call pip on every invocation? Why not just add a requirements.txt file to the tools directory?
I thought it should be a venv independent utility. Better will add to requirements.
I think so - but let's do it only in the tools subdirectory so it doesn't pollute the venv for the rest of the app.