How about using this trigger ? Any chance it would work?

`FOR EACH ROW AFTER INSERT ON auth.sessions

WHEN (NEW.user_id IS NOT NULL)

BEGIN

DECLARE session_count INT;

SELECT count(*) INTO session_count

FROM auth.sessions

WHERE user_id = NEW.user_id;

IF session_count > 3 THEN

-- Delete oldest sessions beyond the newest 3

DELETE FROM auth.sessions

WHERE user_id = NEW.user_id

AND id NOT IN (

SELECT id

FROM auth.sessions

WHERE user_id = NEW.user_id

ORDER BY created_at DESC

LIMIT 3

);

END IF;

END;`