In Drupal 8+ you can do the following:

$regex = '[\W]';
$query->addExpression("column, :regex, '')", 'alias', [':regex' => $regex]);