For new projects, we recommend that you use the new Managed Service for Apache Flink Studio over Kinesis Data Analytics for SQL Applications. Managed Service for Apache Flink Studio combines ease of use with advanced analytical capabilities, enabling you to build sophisticated stream processing applications in minutes.
Kinesis Data Analytics SQL Reference
For information about the SQL language elements that are supported by Kinesis Data Analytics, see Kinesis Data Analytics SQL Reference.