IntelliJ IDEA

Maia brings you the support of Apache Derby SQL dialect. Just as with all others, you can set it at project, folder and individual file levels either via Project Settings section of Settings dialog:Or by invoking a quick-fix on any error marker inside of an .sql file with Alt+Enter shortcut:…