A direct database connection means almost all of your queries will work without any error handling. Using an API requires you to handle lost connection every time you make a request.
Direct database connections almost always are orders of magnitude faster, especially when joins are involved.
Direct database connections almost always are orders of magnitude faster, especially when joins are involved.