Ergest Xheblati recently hosted a hands-on SQL workshop where he shared his expertise on query decomposition patterns, query maintainability patterns, and query performance patterns. Through examples and real-life scenarios, Ergest demonstrated how to break down complex queries into smaller, independent pieces using Common Table Expressions (CTEs), making them more readable and maintainable. He also discussed the importance of following rules for query performance, such as avoiding sort operations until the final SELECT statement, reducing data before joining it, and keeping WHERE clauses simple. The workshop covered various questions from SQL practitioners worldwide, with Ergest providing valuable insights on topics like CTE usage, commenting in SQL, and the differences between CTEs and temp tables.