Merged PRs

dolt

• 10110: #7628: Refactor dolt backup to use SQL interface
  Fixes #7628
  The dolt backup command now interfaces through SQL to execute stored procedure dolt_backup. The dolt_backup procedure now supports HTTP and HTTPS URLs for add, restore, and sync-url parameters as a result. AWS flags are also supported for the above too, but only outside of the sql-server (this goes for both CLI and SQL interfaces).
  • Removed DoltEnv-based subcommand implementations and replaced them with calls to stored procedure dolt_backup.
  • Updated schema for dolt_backups to include params column.
  • Added support for HTTP and HTTPS in dolt_backup procedure's add, restore, and sync-url parameters. We implicitly use the dialer provided by Session.Provider() to get remote databases.
  • Added helper/remotesrv-common.bash with remotesrv_start, remotesrv_stop, and wait_for_port functions to test dolt backup against HTTP remote server.
  • Updated stored procedure test harness to use local system files for dolt_backup.
  • Removed backup.bats from local-remote.bash list so tests run on remote server.
  • Add AWS flags --aws-region, --aws-creds-type, --aws-creds-file and --aws-creds-profile to dolt backup restore.'
  • Switch TestDoltStoredProcedures to use local file system due to limitation on InMem.TmpDir() incompatibility.

go-mysql-server

• 3318: #10113: Fix DELETE queries with NOT EXISTS uninitialized subqueries
  Fixes #10113
  DELETE queries with NOT EXISTS subqueries failed because EXISTS expressions did not set the refsSubquery flag. This caused DELETE queries to use a simplified analyzer batch that skipped subquery initialization, leaving subqueries without execution builders.
  • Refactor EXISTS expression building to reuse buildScalar() for *ast.Subquery, ensuring refsSubquery is set.
  • Capture the table node for simple DELETE queries before buildWhere() wraps it.
  • Separate concerns between explicit targets and implicit targets in a bool, but keep all targets in the same list to handle wrapped targets.
  • Add WithTargets() method to update targets without changing the explicit/implicit flag.
  • Fix offsetAssignIndexes() fast path to skip when virtual columns are present, using the full indexing path instead.

Closed Issues

• 10113: Dolt attempted to evaluate uninitialized subquery , SQL compatibility adjustment
• 7628: Migrate dolt backup to SQL
• 10008: Implement client certificate authentication