Just got back to looking into this...
After dropping newer (1.0.82) versions of System.Data.SQLite into the module (bin/x32 and bin/x64), I can't create a drive:
New-PSDrive : Could not load file or assembly 'System.Data.SQLite, Version=220.127.116.11, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
Which makes sense, I guess, if the provider was compiled against the older version.
I couldn't be bothered to mess around with <bindingRedirect> in the Powershell config file, so I recompiled to provider from sources with the latest SQLite libs.
Now I can create a drive, but can't connect to it:
PS>new-psdrive -name db -psp SQLite -root "Data Source=c:\temp\mr.db"
Name Used (GB) Free (GB) Provider Root
---- --------- --------- -------- ----
no current SQLite session exists
At line:1 char:1
+ <<<< dir db:\
+ CategoryInfo : InvalidOperation: (:) , InvalidOperationException
+ FullyQualifiedErrorId : GetChildrenDynamicParametersProviderException
I guess something more fundamental changed in System.Data.SQLite that will require a provider change...