(Optionally) expose QueryCompilationContext to method/member translators

Our translators currently aren't passed the query compilation context, and so they lack access to various settings and advanced query compilation features. For example, #31482 added support for escaping wildcard characters for LIKE patterns when the pattern is a parameter; since that requires access to RegisterRuntimeParameter, the translation code had to be moved to the provider's SqlTranslatingExpressionVisitor. Once translators can access the QCC, that code can be moved back to the translator where it belongs.