In DBZ-7273, a query mode feature was added to provide an alternative to using the SQL Server stored procedure for reading the capture instance table.

This new mode, direct, shows a reasonable performance improvement since it avoids the use of a UNION ALL over three unique select statements.

Given this was added in 2.6, and has time to mature potentially, should we consider making this the default to provide better OOTB performance?