> I would love it if I could just write queries and it would automatically add an index or do something else for performance if needed, and possibly report back

> I would love it if I could just write queries and it would automatically add an index or do something else for performance if needed, and possibly report back to me if a query I wrote has particularly bad performance. Azure SQL and Amazon RDS do this - but they’re Cloud-hosted IaaS rather than on-prem. On-prem SQL Server does have similar, but limited capabilities with its Query-Store feature - but I don’t recall any of it being fully automatic - at least not by default: which may or may not be a good thing.