For me the tooling is really the best out of all rdbms's for the developer tools ssdt provides a full api to query and create t-sql like rosylyn but for t-sql:

https://the.agilesql.club/blog/Ed-Elliott/2016-01-07/What-Is...