CODE EXAMPLE FOR SQL

postgresql like case-insensitive

-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john