[Bug] dlevel broken via custom pwsh connection 'hack'

[lowlydba]

Describe the bug
On dlevel tests, /setup_sqlserver_test_plugins/connection_plugins/local_pwsh.py no longer works. Presumably this is from there being updates to the original python file that this replaces.

The full traceback is:
Traceback (most recent call last):
File "/root/ansible/lib/ansible/executor/task_executor.py", line 176, in run
res = self._execute()
File "/root/ansible/lib/ansible/executor/task_executor.py", line 610, in _execute
self._connection = self._get_connection(cvars, templar, current_connection)
~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/ansible/lib/ansible/executor/task_executor.py", line 992, in _get_connection
connection, plugin_load_context = self._shared_loader_obj.connection_loader.get_with_context(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
conn_type,
^^^^^^^^^^
...<3 lines>...
ansible_playbook_pid=to_text(os.getppid())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/root/ansible/lib/ansible/plugins/loader.py", line 895, in get_with_context
self._module_cache[path] = self._load_module_source(resolved_type_name, path)
~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/ansible/lib/ansible/plugins/loader.py", line 833, in _load_module_source
spec.loader.exec_module(module)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^
File "", line 1022, in exec_module
File "", line 488, in _call_with_frames_removed
File "/root/ansible_collections/lowlydba/sqlserver/tests/output/.tmp/integration/user-1rnoz0cd-ÅÑŚÌβŁÈ/tests/integration/targets/setup_sqlserver_test_plugins/connection_plugins/local_pwsh.py", line 30, in
from ansible.module_utils.compat import selectors
ImportError: cannot import name 'selectors' from 'ansible.module_utils.compat' (/root/ansible/lib/ansible/module_utils/compat/init.py)
fatal: [testhost]: FAILED! => {
"msg": "Unexpected failure during module execution: cannot import name 'selectors' from 'ansible.module_utils.compat' (/root/ansible/lib/ansible/module_utils/compat/init.py)",
"stdout": ""
}

To Reproduce
See all recent CI runs for Linux.

Expected behavior
We can use local pwsh to test this collection on the runner.

[lowlydba]

@briantist I haven't dug into this at all yet, but wanted to check in if you had seen it or were aware, to avoid duplicating any efforts.

No worries if not, I'll probably try to spend some time on it before the next minor release as it seems like it might be a blocker for the CI working .

[briantist]

I haven't looked at your actual CI results yet but it might be the same issue as this:

• CI: switch to non-deprecated singular form ansible-collections/community.hashi_vault#459