You can change SQL dialect for any file or directory of the project in Settings | SQL Dialects to get better code assistance.