Pandasql vs PostgREST: What are the differences?
Pandasql: Make python speak SQL. pandasql allows you to query pandas DataFrames using SQL syntax. It works similarly to sqldf in R. pandasql seeks to provide a more familiar way of manipulating and cleaning data for people new to Python or pandas; PostgREST: Automatic REST API for Any Postgres Database. PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.
Pandasql and PostgREST can be primarily classified as "Database" tools.
Pandasql and PostgREST are both open source tools. It seems that PostgREST with 12.5K GitHub stars and 585 forks on GitHub has more adoption than Pandasql with 737 GitHub stars and 109 GitHub forks.