#3612 feat: Automatically quote fully-qualified table names based on the corresponding database dialect
Pull request opened by
edgarrmondragon
SSIA
Summary by Sourcery
Automatically apply dialect-specific quoting to fully-qualified SQL table names and expose dialect-aware name generation from the SQL connector.
New Features:
• Support passing an optional SQLAlchemy dialect into FullyQualifiedName to enable dialect-aware formatting and quoting of table identifiers.
Enhancements:
• Update FullyQualifiedName to quote identifier parts when a dialect is provided while preserving unquoted behavior when no dialect is set.
• Make SQLToJSONSchema.get_fully_qualified_name an instance method that uses the connector's configured dialect when constructing fully-qualified table names.
Tests:
• Extend fully-qualified name tests to cover both quoted and unquoted behaviors depending on whether a dialect is supplied.
meltano/sdk