Whenever you have an editor with SQL in it, like the SQL Editor or View Editor, you can use the AI Assistant quick menu for some template actions. Besides explaining the current statement, the AI Assistant can help you to fix your statement when there's errors.
Because the AI Assistant adds context, it will check your table names, column names and syntax for database functions.
As you can see in this example, the AI Assistant is intelligent enough to determine what you're trying to achieve and provide fixes for you.
You can use the button to replace the current SQL and try out the changes.