Invoke-MySQLiteQuery.ps1 does not handle malformed SQL queries gracefully. It currently produces a succession of errors that may be difficult for average users to parse.
I have implemented an error delegate script-block to handle exceptions and, if possible, give the user query feedback as provided by the System.Data.SQLite.SQLiteException internals (available through $Error[2].Exception.InnerException.Message -split "`n" when encountering the error).
Invoke-MySQLiteQuery.ps1does not handle malformed SQL queries gracefully. It currently produces a succession of errors that may be difficult for average users to parse. I have implemented an error delegate script-block to handle exceptions and, if possible, give the user query feedback as provided by theSystem.Data.SQLite.SQLiteExceptioninternals (available through$Error[2].Exception.InnerException.Message -split "`n"when encountering the error).