# Diving into polymorphic table functions with Trino

DevFeed: [Diving into polymorphic table functions with Trino](<https://devfeed.tech/articles/diving-into-polymorphic-table-functions-with-trino-8681.md>)

Original publisher: [Read original article](<https://trino.io/blog/2022/07/22/polymorphic-table-functions.html>)

Author: Kasia Findeisen, Brian Olsen, and Cole Bowden

Published: 2022-07-22T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [blog-post](<https://devfeed.tech/tags/blog-post.md>), [bridge](<https://devfeed.tech/tags/bridge.md>), [connectors](<https://devfeed.tech/tags/connectors.md>), [data](<https://devfeed.tech/tags/data.md>), [external](<https://devfeed.tech/tags/external.md>), [post](<https://devfeed.tech/tags/post.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This Trino blog post introduces polymorphic table functions (PTFs), whose returned table schema is determined dynamically from their arguments. It explains how table functions differ from scalar, aggregate, and window functions, and describes Trino's release 381 support, including connector-executed table functions and query pass-through for JDBC-based connectors and Elasticsearch.

## Source excerpt

In the Trino community, we know that being the coolest query engine is a tough job. We boldly face the intricacies of the SQL standard to bring you the newest and most powerful features. Today, we proudly announce that as of release 381, Trino is on its way to full support for polymorphic table functions (PTFs). In this blog post, we are explaining the concept of table functions and exploring how they can be leveraged. We also look at what we have already implemented, and take a sneak peek into the future.