__toString() — Magic function to convert the query to a string, only for postgresql specific query
castAsChar() — Casts a value to a char.
clear() — Clear data from the query or a specific clause of the query.
concatenate() — Concatenates an array of column names or values.
currentTimestamp() — Gets the current date and time.
dateAdd() — Add to the current date and time in Postgresql.
day() — Used to get a string to extract day from date column.
forShare() — Sets the FOR SHARE lock on select's output row
forUpdate() — Sets the FOR UPDATE lock on select's output row
hour() — Used to get a string to extract hour from date column.
limit() — Set the LIMIT clause to the query
minute() — Used to get a string to extract minute from date column.
month() — Used to get a string to extract month from date column.
noWait() — Sets the NOWAIT lock on select's output row
offset() — Set the OFFSET clause to the query
processLimit() — Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset.
returning() — Add the RETURNING element to INSERT INTO statement.
second() — Used to get a string to extract seconds from date column.
setLimit() — Sets the offset and limit for the result set, if the database driver supports it.
year() — Used to get a string to extract year from date column.

Inherited from JDatabaseQuery

public

__call() — Magic method to provide method alias support for quote() and quoteName().
__clone() — Method to provide deep copy support to nested objects and arrays when cloning.
__get() — Magic function to get protected variable value
__toString() — Magic function to convert the query to a string.
call() — Add a single column, or array of columns to the CALL clause of the query.
castAsChar() — Casts a value to a char.
charLength() — Gets the number of characters in a string.
clear() — Clear data from the query or a specific clause of the query.
columns() — Adds a column, or array of column names that would be used for an INSERT INTO statement.
concatenate() — Concatenates an array of column names or values.
currentTimestamp() — Gets the current date and time.
dateAdd() — Add to the current date and time.
dateFormat() — Returns a PHP date() function compliant date format for the database driver.
day() — Used to get a string to extract day from date column.
delete() — Add a table name to the DELETE clause of the query.
dump() — Creates a formatted dump of the query for debugging purposes.
escape() — Method to escape a string for usage in an SQL statement.
exec() — Add a single column, or array of columns to the EXEC clause of the query.
format() — Find and replace sprintf-like tokens in a format string.
from() — Add a table to the FROM clause of the query.
group() — Add a grouping column to the GROUP clause of the query.
having() — A conditions to the HAVING clause of the query.
hour() — Used to get a string to extract hour from date column.
innerJoin() — Add an INNER JOIN clause to the query.
insert() — Add a table name to the INSERT clause of the query.
join() — Add a JOIN clause to the query.
leftJoin() — Add a LEFT JOIN clause to the query.
length() — Get the length of a string in bytes.
minute() — Used to get a string to extract minute from date column.
month() — Used to get a string to extract month from date column.
nullDate() — Get the null or zero representation of a timestamp for the database driver.
order() — Add a ordering column to the ORDER clause of the query.
outerJoin() — Add an OUTER JOIN clause to the query.
quote() — Method to quote and optionally escape a string to database requirements for insertion into the database.
quoteName() — Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.
rightJoin() — Add a RIGHT JOIN clause to the query.
second() — Used to get a string to extract seconds from date column.
select() — Add a single column, or array of columns to the SELECT clause of the query.
set() — Add a single condition string, or an array of strings to the SET clause of the query.
setQuery() — Allows a direct query to be provided to the database driver's setQuery() method, but still allow queries to have bounded variables.
union() — Add a query to UNION with the current query.
unionAll() — Add a query to UNION ALL with the current query.
unionDistinct() — Add a query to UNION DISTINCT with the current query. Simply a proxy to Union with the Distinct clause.
update() — Add a table name to the UPDATE clause of the query.
values() — Adds a tuple, or array of tuples that would be used as values for an INSERT INTO statement.
where() — Add a single condition, or an array of conditions to the WHERE clause of the query.
year() — Used to get a string to extract year from date column.