Determining database driver and version to handle different databases' capabilities is tricky, this PR adds a new is method to Connection for convenient driver and version comparison.

Usage

Almost all these syntaxes are currently used on the framework:

DB::is('mysql'); // true|false

DB::is('pgsql', '>=', '9.5'); // true|false

DB::is(['mysql', 'mariadb']); // true|false

DB::is([['mysql', '<', '8.0.3'], ['mariadb', '<', '10.5.2']]); // true|false

DB::is(['sqlite' => ['>', '3.35.0'], 'vitess' => ['>', '19.0']]); // true|false

DB::is(fn ($driver, $version) => $driver === 'pgsql' && version_compare($version, '10.0', '<')); // true|false

DB::is(fn ($driver) => $driver === 'sqlsrv' ? 'datetime' : 'timestamp'); // 'timestamp'|'datetime'

Why?

The best reason is the changed code of this PR. We need this method to check driver and actual version of the database to handle different grammar syntaxes, features and capabilities of each one.

Support

Supported drivers are based on the current usage on the framework, maridb, mysql, sqlite, pgsql, sqlsrv and vitess (i.e PlanetScale).
Other databases (e.g. SingleStoreDB, CockroachDB, Supabase, etc.) may be added later.