Issues arise when you're dealing with multiple languages. Say, if you're working on a Java app (which uses camelCase) backed by a Postgres database (which uses snake_case).

Postgres in particular has case-sensitivity quirks if you try to force the use of camelCase table names.