wpdb::get_table_from_query() doesn't support queries with `SET STATEMENT ... FOR`

[dd32]

MariaDB supports setting various parameters for queries, but wpdb::get_table_from_query() doesn't currently understand this.

​https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-statement

For example:

wp> var_dump( $wpdb->get_table_from_query( "SET STATEMENT max_statement_time=10 FOR SELECT something FROM table_name WHERE something-is-expensive" ) );
bool(false)

I'm not sure how useful supporting this would be to most WordPress plugins, nor how it would apply to other database engines.

Trac ticket: https://core.trac.wordpress.org/ticket/63777

[SergeyBiryukov]

In 60622:

Database: Add support for SET STATEMENT in wpdb::get_table_from_query().

MariaDB supports setting various parameters for queries. This commit ensures that wpdb can properly retrieve the table name from such queries.

Reference: ​MariaDB Documentation: SET STATEMENT.

Follow-up to [30345].

Props dd32.
Fixes #63777.