QueryBuilder API provides another way to execute queries without using prepared statements. QueryBuilder has many methods to help generate dynamic queries. Some of these methods are as follows:
- Methods to select/insert/update/delete: select() and update(String table)
- Methods representing a WHERE clause: eq(String name, Object value)
- Methods representing an assignment: set(String name, Object value)
We will look at the QueryBuilder API to build the INSERT, UPDATE, and SELECT statements.
