SET

SET param = value

SET profile = 'profile-name-from-the-settings-file'

-- These are equivalent:
SET force_index_by_date = 1
SET force_index_by_date

SET TIME ZONE [=] 'timezone'

SET TIME ZONE 'UTC';
SET TIME ZONE 'Europe/Amsterdam';
SET TIME ZONE 'America/New_York';

-- Verify the current session time zone
SELECT getSetting('session_timezone');

SET param_name = value

SET param_id = 42;
SET param_name = 'John';

SELECT * FROM users
WHERE id = {id: UInt32}
AND name = {name: String};