[mariadb/mysql] does not support named placeholders like :col1 - use ? instead

[spidgorny]

[mariadb/mysql] does not support named placeholders like :col1 - use ? instead

const jsonSql = require("json-sql")({
  namedValues: false,
  valuesPrefix: "$$",
});
jsonSql.setDialect("mysql");
    const sql = jsonSql.build({
      type: "update",
      table: "table1",
      condition: {
        guid: id,
      },
      modifier: updateFields,
    });
/// CONVERT placeholders
const query1 = sql.query.replace(/\$\$\d+/g, "?");

Maybe this can be built into the mysql dialect?

[titanism]

FYI - don't want to spam here, but we have just released a fork of this project called json-sql-enhanced at https://github.com/forwardemail/json-sql-enhanced. It is modern and maintained, and we accept issues and pull requests.
Thank you 🙏

our fork supports placeholders