tms_drivers driver SELECT search queries

Find a driver with their phone number

SELECT
    index,
        uuid,
        org_uuid,
        company_uuid,
        phone_number,
        deleted_state,
        COALESCE(pgp_sym_decrypt(
                driver.details, '<DRIVER_DETAILS_ENCRYPTION_KEY>'
        )::jsonb, '{}'::jsonb) AS details
FROM driver
WHERE         COALESCE(pgp_sym_decrypt(
                driver.details, '<DRIVER_DETAILS_ENCRYPTION_KEY>'
        )::jsonb, '{}'::jsonb)->>'phone_number' = '+358123456789';

Wildcard find a driver with a part of their name

SELECT
    index,
        uuid,
        org_uuid,
        company_uuid,
        phone_number,
        deleted_state,
        COALESCE(pgp_sym_decrypt(
                driver.details, '<DRIVER_DETAILS_ENCRYPTION_KEY>'
        )::jsonb, '{}'::jsonb) AS details
FROM driver
WHERE         COALESCE(pgp_sym_decrypt(
                driver.details, '<DRIVER_DETAILS_ENCRYPTION_KEY>'
        )::jsonb, '{}'::jsonb)->>'name' LIKE '%PART_OF_NAME%'