Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables?

My company is migrating from Mode Analytics to Domo, and I'm trying to understand whether and how I can run ad-hoc SQL queries against arbitrary tables. As a software engineer, I regularly use Mode's [query editor](https://mode.com/help/articles/querying-data/) to gain insights into our PostgreSQL database data in real-time and run EXPLAIN to see SQL queries' query plans.

So far, I've managed to set up a federated agent and was able to create Federated DataSets that use the agent, but I could only find the Analyzer's GUI interface for querying data.

Does Domo actually have no support for running ad-hoc SQL queries?

Also, would I need to manually create a Federated DataSet for each database table that I'd want to query?

Tagged: