SelectBuilder

What it does

This class acts as a builder for creating database SELECT queries in Magento 2.

Developers use it to programmatically construct complex SQL queries by setting various query components (columns, joins, filters, sorting, grouping) through setter methods, then calling create() to generate the final Select object for database operations.

Public Methods

• getJoins()
• setJoins()
• getConnectionName()
• setConnectionName()
• getColumns()
• setColumns()
• getFilters()
• setFilters()
• getFrom()
• setFrom()
• create()
• getGroup()
• setGroup()
• getSort()
• setSort()
• getParams()
• setParams()
• getHaving()
• setHaving()
• getQueryConfig()