Test fixtures aren't not valid ansi sql

[hfhbd]

Dialect

SQLite

Failing SQL

SELECT 42 WHERE 1 = ?1;

Description

Unfortunately, there is no real ANSI sql standard, because the standard itself is not very strict and every vendor has custom dialects. But the test fixtures should be dialect agnostic as possible.

This includes:

• No ?1 because this syntax isn't supported by all dialects (eg PostgreSQL R2DBC or DB2)
• Always add a FROM clause. While almost all dialects do support omitting the FROM clause, DB2 does not.

One simple option split the test fixtures and the variable into ansi sql and common sql (name to be discussed), which contains the failing test fixtures.