Pwsh-core is cross-platform part of pwsh. pwsh's difference with any nix shell is that operating unit is an object instead of a line of text.
Its drives can be thought conceptually of as children of root (can be confusing since root is part of a filesystem, which is just one drive in pwsh).
So theoretically, you can mount any object source as a drive, including sql servers and work on it with pwsh functions to inspect objects -- relations and records in this case.