#10015 test: Address SQLite `ResourceWarning`s Pull request opened by edgarrmondragon Description Checklist • I have read the contribution guide Was generative AI tooling used to co-author this PR? • Yes (please specify the tool below) Generated-by: [Claude Code] following the agentic coding guidelines Related Issues • Closes #XXXX Summary by Sourcery Ensure SQLite test engines are properly disposed to avoid resource warnings. Bug Fixes: • Dispose in-memory SQLite engines in tests via generator-based fixtures to prevent ResourceWarning leaks. Tests: • Refactor test fixtures to yield and dispose SQLAlchemy engines and engine/sessionmaker pairs instead of returning them directly. meltano/meltano