Support database table prefixing

Currently we are using select queries → , which already supports database prefixing, as they are automatically added by Drupal API.

If your wordpress database has a database prefix, it should be declared at database definition at settings.php (or other settings file) .

Example:

$databases['legacy']['default'] = [
  'database' => 'legacy',
  'username' => 'db',
  'password' => 'db',
  'prefix' => 'elem_',
  'host' => $host,
  'port' => $port,
  'driver' => $driver,
];

This example adds the 'prefix' => 'elem_', property to let Drupal nows the database prefix on queries. This should fix the issue. Indeed, I had to do this on my project to make it works with a wordpress site that has database prefixes.

Let me know if that fixes the problem for you.

Marking task as Needs review in the meanwhile.