/**
 * Implements hook_page_attachments().
 */
function module_page_attachments(array &$page) {
  $request = \Drupal::request()->getRequestUri();
  $nid = NULL;
  if (substr($request, 0, 6) == '/node/') {
    $nid = substr($request, 6);
  } else {

//не забываем
use Drupal\Core\Database\Database;
use Drupal\Core\Database\Query\Select;
 
//далее просто пример моего запроса
$connection = Database::getConnection();
$sql = new Select('node__field_tags', 'ft', $connection);
$sql->condition('field_tags_target_id', $tids, 'in');
$sql->leftJoin('taxonomy_term_field_data', 'tfd', 'tfd.tid=ft.field_tags_target_id');
$sql->leftJoin('node_field_data','nfd', 'nfd.nid=ft.entity_id');
$sql->fields('ft', array('field_tags_target_id', 'entity_id'));
$sql->fields('tfd', array('name'));