Proposal for Babelfish Integration with Azure Data Studio and PostgreSQL Tools Service

[shah-nirmit]

Dear Azure Data Studio and PostgreSQL Tools Service maintainers,

We are reaching out from the AWS team working on Babelfish for PostgreSQL to propose a collaboration that we believe could benefit the broader database community. We own and maintain the github repository for the project.

Project Background:
Babelfish for PostgreSQL is an open-source project (Apache 2.0 and PostgreSQL licenses) that enables PostgreSQL to understand and process T-SQL queries, allowing applications written for Microsoft SQL Server to run on PostgreSQL with minimal changes.

GitHub repositories:

• https://github.com/babelfish-for-postgresql/babelfish_extensions
• https://github.com/babelfish-for-postgresql/postgresql_modified_for_babelfish

Proposal:
We've identified a need for a robust GUI tool to interact with Babelfish. Given Azure Data Studio's extensibility and database-agnostic nature, we believe it could be an excellent fit for Babelfish users.

We would like to explore the possibility of collaborating to extend the following projects:

1. https://github.com/microsoft/azuredatastudio-postgresql
2. https://github.com/microsoft/pgtoolsservice

The goal would be to add Babelfish as a data source option within these extensions, enhancing their utility for users working with Babelfish-enabled PostgreSQL instances.

Benefits:

• Expanded functionality for Azure Data Studio users
• Improved tooling support for Babelfish adopters
• Potential for increased community engagement and contributions

Next Steps:

• We look forward to adding/extending Azure Data Studio for Babelfish and continue to contribute and enable community contributions to enhance the same.

We look forward to your thoughts on this potential collaboration and are eager to answer any questions you may have.

Thank you for your time and consideration.

Best regards,
AWS Babelfish Team