Executes a SQL query and returns the rows
You can execute multiple statements in a transaction by separating them with a semicolon.
If you are using prepared statements, each statement must use all of the prepared parameters.
Generally you should avoid using destructive actions like DELETE, UPDATE, TRUNCATE, etc., though the user is ultimately responsible for managing the permissions of the SQL user / connection combo.
If you run multiple SELECT statements, the results will be concatenated together into a single array.
If you are unsure about the schema of the database, DO NOT GUESS! You can use the `schema` endpoint to retrieve the schema of the database.
However, if the user has asked you for a query directly, you can just run that query and return the results. - PostgreSQL - Miniforge