Replace static queries with dynamic queries in InsertDefaultsTest.php file

In core/tests/Drupal/KernelTests/Core/Database/InsertDefaultsTest.php file change static queries to dynamic queries in testDefaultInsert(), testDefaultEmptyInsert() and testDefaultInsertWithFields() methods.

Problem/Motivation

As per title

Proposed resolution

$num_records_before = (int) $this->connection->query('SELECT COUNT(*) FROM {test}')->fetchField();
-
+    $num_records_before = $this->connection->select('test')
+      ->countQuery()
+      ->execute()
+      ->fetchField();

-    $job = $this->connection->query('SELECT job FROM {test} WHERE id = :id', [':id' => $id])->fetchField();
+    $job = $this->connection->select('test', 't')
+      ->fields('t', ['job'])
+      ->condition('id', $id)
+      ->execute()
+      ->fetchField();

Remaining tasks

TBD

User interface changes

None

API changes

None

Data model changes

None

Release notes snippet

TBD