Your question is very interesting!
I have previously enabled Babelfish.
I think you can use the same procedure to create an Aurora PostgreSQL with Babelfish enabled and specify the Aurora host in connectionStrings.
Entity Framework should issue standard SQL queries to Aurora (TDS), so I think it works unless you have a special query syntax.
How do I see execution plans or optimize queries in Babelfish?Accepted Answer
If I use both the PostgreSQL and TDS port with Babelfish, what should I know?Accepted Answer
How do I know if Babelfish supports my SQL Server application?Accepted Answer
Where can I find Babelfish release notes or recent features?Accepted Answer
What port does Babelfish work over and should I be able to test with osql?asked a year ago
How do I move an Entity Framework or EF Core app with Babelfish?
What are the limitations of Babelfish?Accepted Answer
Babelfish: How do I get started?Accepted Answer
Does Babelfish support XML? How can I use XML?
Tag request for Babelfish