tms_drivers decrypt driver detail database cells
This query can be used to decrypt encrypted values in the database:
SELECT
driver_company.org_uuid,
driver.uuid,
COALESCE(pgp_sym_decrypt(
driver.details, '<DRIVER_DETAILS_ENCRYPTION_KEY>'
)::jsonb, '{}'::jsonb)->>'phone_number' as phone_number
FROM driver
JOIN driver_company ON driver.index = driver_company.driver_index
WHERE driver_company.org_uuid = '<ORGANIZATION_UUID';