Panoply supports user-defined functions (UDFs), which expand your ability to perform data manipulation when querying data.
You can create SQL-based UDFs or Python-based UDFs. You create UDFs through a workbench, including Panoply's workbench or any external workbench. And you can use UDFs within any query.
For more information, see Creating User-Defined Functions in the Amazon Redshift Database Developer Guide.
For an explanation of why Python-based UDFs can be useful, see Introduction to Python UDFs in Amazon Redshift from the AWS Big Data Blog.