Now T210206: Deprecate raw SQL conditions for IDatabase methods (select, insert, etc.) is mostly done, devs should start migrating their codebases away from building raw SQL.

See below as examples of adoption:

• https://gerrit.wikimedia.org/r/c/mediawiki/core/+/970792/
• https://gerrit.wikimedia.org/r/c/mediawiki/core/+/967554/
• https://gerrit.wikimedia.org/r/c/mediawiki/core/+/972431/

Also these regexes can migrate simple cases:

'([A-Za-z_\.]+) ?(=|!=|<|<=|>|>=) ?' . (\$db(?:r|w|))->addQuotes\( (.+?) \)
to:
$3->expr\( '$1', '$2', $4 \)

and

'([A-Za-z_\.]+) IS NULL OR ([A-Za-z_\.]+) ?(=|!=|<|<=|>|>=) ?' . (\$db(?:r|w|))->addQuotes\( (.+?) \)
to:
$4->expr( '$1', '=', null )->or\( '$2', '$3', $5 \)

and

'([A-Za-z_\.]+) IS NOT NULL OR ([A-Za-z_\.]+) ?(=|!=|<|<=|>|>=) ?' . (\$db(?:r|w|))->addQuotes\( (.+?) \)
to:
$4->expr( '$1', '!=', null )->or\( '$2', '$3', $5 \)

Replacements for functions:

• ISQLPlatform::unionQueries => UnionQueryBuilder::execute
• ISQLPlatform::selectSQLText => SelectQueryBuilder::getSQL
• ISQLPlatform::buildSelectSubquery => SelectQueryBuilder::getSQL + new Subquery
• ISQLPlatform::buildGroupConcatField => SelectQueryBuilder::buildGroupConcatField
• ISQLPlatform::makeList => Expression::or / Expression::and / IReadableDatabase::orExpr / IReadableDatabase::andExpr
• ISQLPlatform::buildLike => IReadableDatabase::expr + IExpression::LIKE/IExpression::NOT_LIKE + new LikeValue
• DbQuoter::addQuotes => IReadableDatabase::expr (not all can be replaced, for example when used with other ISQLPlatform::build* functions)