#3198 feat: Update SQL tap and target templates with latest APIs
Pull request opened by
edgarrmondragon
• Closes
#1347
---
📚 Documentation preview 📚:
https://meltano-sdk--3198.org.readthedocs.build/en/3198/
## Summary by Sourcery
Refresh SQL tap and target cookiecutter templates to align with the latest Singer SDK APIs by adding customizable SQL type conversion, advanced connector and stream override examples, and dynamic sink template selection.
New Features:
• Add a SQLToJSONSchema subclass with singledispatch methods for custom SQL-to-JSON Schema conversions.
• Extend SQLConnector and SQLStream templates with example override methods for schema discovery, type conformance, query filtering, and custom record retrieval.
• Provide separate RecordSink, BatchSink, and SQLSink template files and a post-generation hook to select and clean up the appropriate sink based on the serialization method.
Enhancements:
• Enrich docstrings and developer guidance across tap and target template classes.
• Update the post-gen hook to remove IDE folders and handle sink file selection and cleanup.
meltano/sdk