Are there any other Redshift functions to be implemented this year?

Based on the available information, there's no specific mention of upcoming window function enhancements like RANGE BETWEEN for Amazon Redshift in 2024 or 2025.

The most recent SQL feature announcements for Amazon Redshift were three new features for zero-ETL integrations announced in January 2025: QUERY_ALL_STATES (allowing queries on tables during updates), TRUNCATECOLUMNS (automatically truncating VARCHAR data exceeding length limits), and ACCEPTINVCHARS (replacing invalid UTF-8 characters with specified characters).

Throughout 2024, Amazon Redshift has focused on several other areas of enhancement including:

• Zero-ETL integrations with various AWS databases and third-party applications
• Support for Confluent Cloud and Apache Kafka
• Auto-copy functionality for Amazon Redshift
• Enhanced VPC routing warehouses in zero-ETL integration

While Amazon Redshift regularly releases patches and updates with new features, there's no specific information in the provided sources about upcoming window function enhancements like RANGE BETWEEN to complement the existing ROWS BETWEEN functionality.
Sources
Recap of Amazon Redshift key product announcements in 2024 | AWS Big Data Blog
Amazon Redshift introduces new SQL features for zero-ETL integrations - AWS