CodeIgniter 4 Query Builder

When to use

• The user wants to build a SELECT, INSERT, UPDATE, or DELETE query in CodeIgniter 4 using the Query Builder.
• The user needs to fetch and iterate CodeIgniter query results as arrays, objects, or entity instances.
• The user needs to filter query results by user-supplied values without risking SQL injection.

When NOT to use

• Do not force complex window functions or vendor-specific analytical SQL through the builder; use a parameterized raw query.
• Do not use this skill for schema changes (CREATE TABLE, ALTER); use Forge and migrations instead.

Core guidance