How to switch database connections in Drupal 8

// Switch to external database
\Drupal\Core\Database\Database::setActiveConnection('d7migration');

// Get the connection
$db = \Drupal\Core\Database\Database::getConnection();

$query = $db->select('node', 'n');
$query->fields('n', array('title'…

How To Get List Field Values As Labels Instead Of Keys

So you have a regular list text field in your entity and instead of keys, you want to get values. How do you do that? Well as usual in Drupal it will be painful 🤕 but possible 🙌:

How To Get A Title Of The Referenced Entity

So, I have a node that has an entity reference field field_book that points to another node (obviously, a Book node).

So now I want to get a title of the referenced book node. How do I do that?

How To Get Entity Url in Drupal 8

$node->toUrl()->toString();

😭😭😭

How to do SELECT query

$query = \Drupal::database()->select('node', 'n');
$query->fields('n', ['title', 'status']);
$result = $query->execute();
foreach ($result as $row) {
  print($row->title);
  print($row->status);
}