It’s easy to access an SQL Server database from an Anvil app!
Because an Anvil app has a full Python instance in the back-end, you can use an SQL Server driver such as
pymssql to control your MS SQL database, as you would in any Python environment.
No, you don’t!
Anvil also has a built-in database system called Data Tables (here’s a tutorial). Data Tables have visual designer for composing a schema, and Python methods for searching. Data Tables is backed by PostgreSQL, which provides robustness and scalability. On the business plan, Data Tables can be accessed in SQL, but most users prefer to use the Python API.