Add SQLite compatibility to wp db commands (#299)

Co-authored-by: swissspidy <841956+swissspidy@users.noreply.github.com>
Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>
Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
Co-authored-by: Pascal Birchler <pascalb@google.com>

Merge pull request #297 from wp-cli/fix/tests

Merge pull request #281 from wp-cli/fix-gherkin-issues

Fix Gherkin lint issues

Merge pull request #273 from wp-cli/no-lock-file

Merge pull request #257 from wp-cli/fix/trunk-tests

Update tests after change in WP trunk

Enable `--format=<format>` for `db search` (#247)

* Enable formatter for search command

* Use `value` instead of `ID` for the primary key column

* Rename and reorder the columns

* Update docs

* Less brittle test

---------

Co-authored-by: Daniel Bachhuber <daniel.bachhuber@automattic.com>

Merge pull request #249 from wp-cli/248-skip-column-names

Update to WPCS v3 (#240)

* Update to wp-cli-tests v4 (which requires WPCS v3)

* Fix all autofixable CS issues

* Avoid nested control structure

* Fix linting issue

---------

Co-authored-by: Daniel Bachhuber <daniel.bachhuber@automattic.com>

Add `composer phpcbf` (#236)

Fix retrieval of get_post_table_characterset (#231)

Query command run through `assoc_args_to_str` get double quotes truncated and fail to execute. 

Using single quotes in the query prevent error.

`Warning: Failed to get current character set of the posts table. Reason: ERROR at line 1: Unknown command '\_'`

Error may be more prominent on windows.