如何使用powershell自动化SQL查询和创建Excel文件?

I have an XML file that our practice management software (PMS) uses to query its MS SQL database and create and Excel report of the results. Unfortunately the PMS doesn't have the ability to schedule this as a task for automation at regular intervals and they've said it's out of their scope of support.I have an XML file that our practice management