Why would I use this instead of just using e.g. a postgres jdbc driver? How would I use this? A query compiler library (or service)? How do you do a join? Group

Why would I use this instead of just using e.g. a postgres jdbc driver? How would I use this? A query compiler library (or service)? How do you do a join? Group by? CTEs? Window functions? Transactions? Bulk inserts/updates? Index and constraint management? Temporary tables? Why does the read endpoint have a hard limit?