Ansible playbook for updated file listing

[chris (Chris Croome)]

What does subfolders look like, try adding a debug for this and post the result here?

- name: Debug subfolders
  ansible.builtin.debug:
    var: subfolders

Also try setting use_regex to false as *.sql is a shell pattern?