AWS Glue Studio now supports transforms defined in SQL

AWS Glue Studio now provides the option to define transforms using SQL queries, allowing you to perform aggregations, easily apply filter logic to your data, add calculated fields, and more. This feature makes it easy to seamlessly mix SQL queries with AWS Glue Studio’s visual transforms while authoring ETL jobs.

Source:: Amazon AWS