Connect to Turbot Pipes with pgcli
Since your Turbot Pipes workspace is just a PostgreSQL database, you can use
pgcli to query your workspace database.
The Connect tab for your workspace will provide the command, including Postgres connection string for your workspace.
Note that the connection string includes your password. It is masked in the web console display, but you can hover over the command and click the clipboard icon to copy it so you can paste it into your terminal.