How one can Get an RDBMS Server Model with SQL – Java, SQL and jOOQ.

-- CockroachDB
choose model();

-- Db2
choose service_level from desk (sysproc.env_get_inst_info()) t

-- Derby
choose getdatabaseproductversion() from (values (1)) t (a);

-- Exasol
choose param_value 
from exa_metadata 
the place param_name="databaseProductVersion";

-- Firebird
choose rdb$get_context('SYSTEM', 'ENGINE_VERSION')
from rdb$database;

-- H2
choose h2version(); 

-- HANA
choose * from m_database;

-- HSQLDB
choose character_value
from information_schema.sql_implementation_info
the place implementation_info_name="DBMS VERSION"

-- Informix
choose dbinfo('model', 'full') from systables the place tabid = 1;

-- MariaDB
choose model();

-- MemSQL (SingleStore)
choose model();

-- MySQL
choose model();

-- Oracle
choose * from v$model;

-- PostgreSQL
choose model();

-- Snowflake
choose current_version();

-- SQL Server
choose @@model;

-- SQLite
choose sqlite_version();

-- Teradata
choose infodata from dbc.dbcinfov the place infokey = 'VERSION'