OracleDialect + NamingScheme does not work with subqueries

[tOverney]

Upgraded from 3.5.1 and expected for everything to work out of the box but it seems the change done for aliasing in the subqueries does not work for the OracleDialect (tested with H2Dialect and it works fine)

Version: 3.6.0 Module: quill-jdbc Database: Oracle

Expected behavior

As described in the changelog, the subqueries should create aliases in camelCase and the main query should use camelCase.

Actual behavior

Aliasing is done with camelCase in the main query but the subquery creates the aliases in snake_case.

Steps to reproduce the behavior

Snippet to showcase the issue: https://scastie.scala-lang.org/QTVtWNNfRPqTNw5sdK5euw

Workaround

I have found none

@getquill/maintainers

[tOverney]

Just tried with 3.5.3 and it exhibit the same behavior

[tOverney]

Bug is still present in 3.12.0:

https://scastie.scala-lang.org/NlikgIH1QhqvYvwoF5R4cA

#2322 Did not fix it

[tOverney]

Bug is still present in 4.3.0:

https://scastie.scala-lang.org/1Ii6N49QR36hJvqNrGVArw