Add support for Common Table Expressions (CTE) to SelectInterface

Problem/Motivation

From Drupal 11, all of the supported DB engine versions will have support for common table expressions (CTEs),
At present to work with these, you need to use \Drupal\Core\Database\Connection::query which lacks the DX of working with SelectInterface

Steps to reproduce

Proposed resolution

Support passing a CTE to \Drupal\Core\Database\Connection::select as the first argument

Remaining tasks

The whole box and dice

User interface changes

API changes

Data model changes

Release notes snippet