Can Panoply pull data from a database, perform transformations, and then push it back to the said database?

Yes, but not entirely.

The Panoply platform serves as your analytical data warehouse. It allows you to collect or pull data from various data sources, like MySQL, into your data warehouse. Once collected, you can transform the data using views or use BI tools or external workbenches.

Pushing the data back to your database is another story, though. It's possible, but it isn't natively supported through the Panoply platform. You can use an external process or an ETL provider to perform this part of the job.