MySqlGrammar

Register a custom macro.

Boot-only. Macros persist in a static property for the worker lifetime and apply to every subsequent call on the macroable class.

Mix another object into the class.

Boot-only. Delegates to macro() for each method; registered macros persist in a static property for the worker lifetime.

Check if macro is registered.

Flush the existing macros.

Boot or tests only. Clears worker-wide macros; concurrent coroutines may resolve different methods depending on timing.

Dynamically handle calls to the class.

Dynamically handle calls to the class.

Create a new grammar instance.

Wrap an array of values.

Wrap a table in keyword identifiers.

Wrap a single identifier in keyword identifiers.

Wrap a value in keyword identifiers.

Wrap a value that has an alias.

Wrap a table that has an alias.

Wrap the given value segments.

Wrap a single string in keyword identifiers.

Wrap the given JSON selector.

Determine if the given string is a JSON selector.

Convert an array of column names into a delimited string.

Create query parameter place-holders for an array.

Get the appropriate query parameter place-holder for a value.

Quote the given string literal.

Escape a value for safe SQL embedding.

Determine if the given value is a raw expression.

Transforms expressions to their scalar types.

Get the format for database stored dates.

Flush all static state.

Split the given JSON selector into the field and the optional path and wrap them separately.

Wrap the given JSON path.

Wrap the given JSON path segment.

Compile a select query into SQL.

Compile a select query without statement-level decoration.

Embedded fragments are assembled by their builder's grammar because connection-owned details such as table prefixes resolve through that grammar. They bypass compileSelect because only a complete executed statement carries statement-level decoration.

Compile the query timeout for a complete select statement.

Compile the components necessary for a select clause.

Compile an aggregated select clause.

Compile the "select *" portion of the query.

Compile the "from" portion of the query.

Compile the "join" portions of the query.

Compile a "lateral join" clause.

Determine if the grammar supports straight joins.

Compile the "where" portions of the query.

Get an array of all the where clauses for the query.

Format the where clause statements into one string.

Compile a raw where clause.

Compile a basic where clause.

Compile a "where binary" clause.

Compile a bitwise operator where clause.

Compile a "where like" clause.

Compile a "where in" clause.

Compile a "where not in" clause.

Compile a "where not in raw" clause.

For safety, whereIntegerInRaw ensures this method is only used with integer values.

Compile a "where in raw" clause.

For safety, whereIntegerInRaw ensures this method is only used with integer values.

Add a "where null" clause to the query.

Add a "where not null" clause to the query.

Compile a "where null safe equals" clause.

Compile a "between" where clause.

Compile a "between" where clause.

Compile a "value between" where clause.

Compile a "where date" clause.

Compile a "where time" clause.

Compile a "where day" clause.

Compile a "where month" clause.

Compile a "where year" clause.

Compile a date based where clause.

Compile a where clause comparing two columns.

Compile a nested where clause.

Compile a where condition with a sub-select.

Compile a where exists clause.

Compile a where not exists clause.

Compile a where row values condition.

Compile a "where JSON boolean" clause.

Compile a "where JSON contains" clause.

Compile a "JSON contains" statement into SQL.

Compile a "where JSON overlaps" clause.

Compile a "JSON overlaps" statement into SQL.

Prepare the binding for a "JSON contains" statement.

Compile a "where JSON contains key" clause.

Compile a "JSON contains key" statement into SQL.

Compile a "where JSON length" clause.

Compile a "JSON length" statement into SQL.

Compile a "JSON value cast" statement into SQL.

Compile a "where fulltext" clause.

Compile a clause based on an expression.

Compile a vector distance expression for the given column.

Determine if the grammar supports vector distance queries.

Compile the "group by" portions of the query.

Compile the "having" portions of the query.

Compile a single having clause.

Compile a basic having clause.

Compile a "between" having clause.

Compile a having null clause.

Compile a having not null clause.

Compile a having clause involving a bit operator.

Compile a having clause involving an expression.

Compile a nested having clause.

Compile the "order by" portions of the query.

Compile the query orders to an array.

Compile an "in order of" clause.

Compile the random statement into SQL.

Compile the "limit" portions of the query.

Compile a group limit clause.

Compile a row number clause.

Compile the "offset" portions of the query.

Compile the "union" queries attached to the main query.

Compile a single union statement.

Wrap a union subquery in parentheses.

Compile a union aggregate query into SQL.

Compile an exists statement into SQL.

Compile an insert statement into SQL.

Compile an insert ignore statement into SQL.

Compile an insert or ignore statement with a returning clause into SQL.

Compile an insert and get ID statement into SQL.

Compile an insert statement using a subquery into SQL.

Compile an insert ignore statement using a subquery into SQL.

Compile an update statement into SQL.

Compile the columns for an update statement.

Group update values by column in order of first appearance.

Compile an update statement without joins into SQL.

Compile an update statement with joins into SQL.

Compile an "upsert" statement into SQL.

Prepare the bindings for an update statement.

Booleans, integers, and doubles are inserted into JSON updates as raw values.

Prepare the bindings for an update statement with joins.

Prepare update values in column order, encoding JSON assignments.

Compile a delete statement into SQL.

Compile a delete query that does not use joins.

Compile a delete query that uses joins.

Adds ORDER BY and LIMIT if present, for platforms that allow them (e.g., PlanetScale). Standard MySQL does not support ORDER BY or LIMIT with joined deletes and will throw a syntax error.

Qualify the row identifier selected by a limited or joined write rewrite.

Prepare the bindings for a delete statement.

Compile a truncate table statement into SQL.

Compile the lock into SQL.

Compile a query to get the number of open connections for a database.

Determine if the grammar supports savepoints.

Compile the SQL statement to define a savepoint.

Compile the SQL statement to execute a savepoint rollback.

Wrap the given JSON selector for boolean values.

Wrap the given JSON boolean value.

Concatenate an array of segments, removing empties.

Remove the leading boolean from a statement.

Substitute the given bindings into the given raw SQL query.

Get the grammar specific operators.

Get the grammar specific bitwise operators.

Compile the index hints for the query.

Determine whether to use a legacy group limit clause for MySQL < 8.0.

Compile a group limit clause for MySQL < 8.0.

Derived from https://softonsofa.com/tweaking-eloquent-relations-how-to-get-n-related-models-per-parent/.

Prepare a JSON column being updated using the JSON_SET function.