IGNITE-9171: SQL: redesigned lazy mode. This closes #5473.