IntelliJ IDEA
IntelliJ IDEA – the Leading Java and Kotlin IDE, by JetBrains
Features
Derby SQL Dialect Support
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: