Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE PEOPLE 
AS 
SELECT 1 AS ID, 'Bob'AS Name, 'Boss' AS TITLE
UNION ALL
SELECT 2, 'Bobbet',NULL

SELECT 2


SELECT ID, Name, TITLE
FROM PEOPLE
WHERE NAME IS NOT DISTINCT FROM 'Bobbet'
 AND TITLE IS NOT DISTINCT FROM NULL


id
name
title


2
Bobbet
null



SELECT 1


SELECT ID, Name, TITLE
FROM PEOPLE
WHERE NAME IS NOT DISTINCT FROM 'Bob'
 AND TITLE IS NOT DISTINCT FROM 'Boss'


id
name
title


1
Bob
Boss



SELECT 1