Using an alias for SQL server seems to be a pretty common thing, however all we did was set the alias in DNS and then start referencing it via ODBC. There is no reverse lookup for the alias.

Second question: During my usage, I found that using aliases causes issues when parsing SQL. This is just a simple example, but there are scenarios in multi-table joins where these aliases are used： ...