SQL with GenAI: Building an Apache Iceberg lakehouse on Red Hat OpenShift

This post discusses the integration of AI functions into SQL queries on a Red Hat OpenShift platform utilizing Apache Iceberg lakehouse architecture. It describes how Trino's AI capabilities allow data engineers and analysts to perform complex data analysis and transformations using SQL without the need for Python or other tools, showcasing multiple use cases like sentiment analysis and entity extraction. The author emphasizes the efficiency, security, and scalability of running AI functions directly within SQL queries, providing insights into practical applications and architectural considerations.