The first step is to switch on exceptions. When bootstrapping PDO, make sure to do:
$opts = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_BOTH,
PDO::ATTR_EMULATE_PREPARES => false,