Azure SQL Server Connectivity

How is Anvil dealing with external databases, in comparisson to Anvil internal data service? It is quite elegant to work with internal data service when dealing with ids, one to many relationships (you deal with rows and not with technicalities). How is that if you choose pymssql or SQLAlchemy?