Merged PRs

dolt

6090: Actually run bats tests in a configuration where all commands connect to a server process.
Due to a typo in the .yaml script, we weren't actually running bats tests with the $SQL_ENGINE environment variable set, which meant that we weren't actually testing the ability for commands to seamlessly connect to running server processes. This PR fixes this.
6065: update dolt blame to use sql backend and accept specific revision
This change updates dolt blame to use the appropriate sql engine to generate results. This change also allows users to specify a specific revision to annotate from.
Related: #3922
6015: Migrate dolt add to use Sql backend.
This PR migrates dolt add to invoke SQL commands instead of manipulating the database directly. This allows it to work even on remote connections.

1811: Hoist subquery filters bug
Hoist filters is supposed to move filters that do not reference tables in the current sope upwards. We did not descend subqueries when checking for that condition, mistakenly hoisting filters in some cases.
Re: #6089
1810: Added many collations and character sets
Added a lot of missing collations and character sets. I had to manually type in all of the new entries in charactersets.go and collations.go, so it's possible I made a mistake. I double checked them all, but I still might have overlooked one.
1809: Add support for JSON -> and ->> operators
MySQL column->path Documentation
MySQL column->>path Documentation
Fixes: #5662

Read Tests	MySQL	Dolt	Multiple
covering_index_scan	1.96	2.76	1.4
groupby_scan	12.3	17.01	1.4
index_join	1.16	4.25	3.7
index_join_scan	1.12	2.14	1.9
index_scan	30.81	55.82	1.8
oltp_point_select	0.15	0.47	3.1
oltp_read_only	2.86	8.13	2.8
select_random_points	0.29	0.77	2.7
select_random_ranges	0.35	1.08	3.1
table_scan	30.81	55.82	1.8
types_table_scan	69.29	158.63	2.3
reads_mean_multiplier			2.4

Write Tests	MySQL	Dolt	Multiple
bulk_insert	0.001	0.001	1.0
oltp_delete_insert	5.57	6.55	1.2
oltp_insert	2.66	3.13	1.2
oltp_read_write	6.79	15.83	2.3
oltp_update_index	2.81	3.19	1.1
oltp_update_non_index	2.81	3.25	1.2
oltp_write_only	4.03	7.84	1.9
types_delete_insert	5.47	7.04	1.3
writes_mean_multiplier			1.4

Overall Mean Multiple	2.0