> And mind you we are only talking about relational ones (the kind JDBC cares about).

It gets even more fun with Java EE where you can have arbitrary resource adapters. So then you have even non-SQL naming conventions to map within your application server.