[PP-2] Enable dynamic queries to produce SQL with positional placeholders

Problem/Motivation

Drupal's dynamic queries produce SQL with named placeholders. In 📌 [PP-1] Create the database driver for MySQLi Postponed , since mysqli is NOT supporting named placeholders, we are introducing an helper class that converts an SQL with named placeholders to one with positional ones.

This is inefficient, since it has to deconstruct a ready SQL statement and rebuild it.

Proposed resolution

Introduce logic that enables dynamic queries to produce SQL with either named or positional placeholders, and prevent mysqli driver to run through the converter if a statement is already built with positional parameters.

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet