Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.

Among the Python frameworks they use are: The Metrics Repo, a Python framework based on PyPika that allows users to write reusable, parameterized SQL queries.