dd/def/query_8hpp_source.html

#pragma once


#include "query/arithmetic.hpp"

#include "query/column_expression.hpp"

#include "query/condition.hpp"

#include "query/core.hpp"

#include "query/date.hpp"

#include "query/delete.hpp"

#include "query/function.hpp"

#include "query/helpers.hpp"

#include "query/insert.hpp"

#include "query/literals.hpp"

#include "query/operators.hpp"

#include "query/schema_adapter.hpp"

#include "query/select.hpp"

#include "query/update.hpp"

#include "query/value.hpp"


namespace relx {


// Convenient imports from the query namespace

using query::as;

using query::asc;

using query::avg;

using query::case_;

using query::coalesce;

using query::count;

using query::count_all;

using query::count_distinct;

using query::delete_from;

using query::desc;

using query::distinct;

using query::in;

using query::insert_into;

using query::like;

using query::max;

using query::min;

using query::on;

using query::select;

using query::select_expr;

using query::sum;

using query::update;

using query::val;


// Date/time functions

using query::abs;

using query::age_in_years;

using query::current_date;

using query::current_time;

using query::current_timestamp;

using query::date_add;

using query::date_diff;

using query::date_sub;

using query::date_trunc;

using query::day;

using query::day_of_week;

using query::day_of_year;

using query::days_since;

using query::days_until;

using query::extract;

using query::hour;

using query::interval;

using query::minute;

using query::month;

using query::now;

using query::second;

using query::start_of_day;

using query::start_of_month;

using query::start_of_year;

using query::year;


// User-defined literals

using namespace query::literals;  // Enables 42_sql, "string"_sql, etc.


// ===== INTERNAL/ADVANCED API =====

// These are implementation details that power users might need

// Most users should not use these directly


namespace detail {

using query::to_expr;

using query::to_table;

}  // namespace detail


}  // namespace relx

arithmetic.hpp

column_expression.hpp

condition.hpp

date.hpp

delete.hpp

function.hpp

helpers.hpp

insert.hpp

literals.hpp

relx::query::current_timestamp
auto current_timestamp()
CURRENT_TIMESTAMP function - returns the current timestamp.
Definition date.hpp:546

relx::query::start_of_day
auto start_of_day(const T &date_column)
Get the start of the day for a date.
Definition date.hpp:644

relx::query::min
auto min(Expr expr)
MIN aggregate function.
Definition function.hpp:186

relx::query::current_time
auto current_time()
CURRENT_TIME function - returns the current time.
Definition date.hpp:540

relx::query::second
auto second(const T &date_column)
Get the second from a timestamp.
Definition date.hpp:772

relx::query::age_in_years
auto age_in_years(const T &birth_date_column)
Calculate age in years between birth date and current date.
Definition date.hpp:564

relx::query::like
auto like(Expr expr, std::string pattern)
Create a LIKE condition.
Definition condition.hpp:221

relx::query::avg
auto avg(Expr expr)
AVG aggregate function.
Definition function.hpp:166

relx::query::hour
auto hour(const T &date_column)
Get the hour from a timestamp.
Definition date.hpp:740

relx::query::interval
auto interval(std::string_view interval_str)
Create an interval expression.
Definition date.hpp:528

relx::query::start_of_month
auto start_of_month(const T &date_column)
Get the start of the month for a date.
Definition date.hpp:628

relx::query::asc
auto asc(Expr expr)
Create an ascending order by expression.
Definition select.hpp:586

relx::query::start_of_year
auto start_of_year(const T &date_column)
Get the start of the year for a date.
Definition date.hpp:612

relx::query::year
auto year(const T &date_column)
Get the year from a date.
Definition date.hpp:660

relx::query::in
auto in(const schema::column< TableT, Name, T, Modifiers... > &col, Range values)
Create an IN condition with type checking for columns.
Definition condition.hpp:132

relx::query::month
auto month(const T &date_column)
Get the month from a date.
Definition date.hpp:676

relx::query::day_of_year
auto day_of_year(const T &date_column)
Get the day of year from a date (1-366)
Definition date.hpp:724

relx::query::extract
auto extract(std::string_view unit, Expr expr)
EXTRACT function - extracts a date part from a date.
Definition date.hpp:497

relx::query::day
auto day(const T &date_column)
Get the day from a date.
Definition date.hpp:692

relx::query::max
auto max(Expr expr)
MAX aggregate function.
Definition function.hpp:206

relx::query::date_add
auto date_add(DateExpr date_expr, IntervalExpr interval_expr)
DATE_ADD function - adds an interval to a date.
Definition date.hpp:460

relx::query::sum
auto sum(Expr expr)
SUM aggregate function.
Definition function.hpp:146

relx::query::desc
auto desc(Expr expr)
Create a descending order by expression.
Definition select.hpp:554

relx::query::update
auto update(const Table &table)
Create an UPDATE query for the specified table.
Definition update.hpp:252

relx::query::as
auto as(const Expr &expr, std::string alias)
Create an aliased column expression.
Definition column_expression.hpp:104

relx::query::select_expr
auto select_expr(const schema::column< TableT, Name, T, Modifiers... > &col, Args &&... args)
Definition operators.hpp:654

relx::query::insert_into
auto insert_into(const Table &table)
Create an INSERT query for the specified table.
Definition insert.hpp:330

relx::query::minute
auto minute(const T &date_column)
Get the minute from a timestamp.
Definition date.hpp:756

relx::query::case_
auto case_()
Create a CASE expression with type checking.
Definition function.hpp:654

relx::query::current_date
auto current_date()
CURRENT_DATE function - returns the current date.
Definition date.hpp:534

relx::query::to_expr
auto to_expr(const C &col, std::string_view table_name="")
Helper to wrap a schema column in a SQL expression.
Definition schema_adapter.hpp:85

relx::query::count_distinct
auto count_distinct(Expr expr)
COUNT(DISTINCT expr) aggregate function.
Definition function.hpp:97

relx::query::count
auto count(Expr expr)
COUNT aggregate function.
Definition function.hpp:81

relx::query::days_until
auto days_until(const T &date_column)
Calculate days until a date.
Definition date.hpp:596

relx::query::date_trunc
auto date_trunc(std::string_view unit, Expr expr)
DATE_TRUNC function - truncates a date to specified precision.
Definition date.hpp:514

relx::query::days_since
auto days_since(const T &date_column)
Calculate days since a date.
Definition date.hpp:580

relx::query::select
auto select(const Args &... args)
Create a column reference from a member pointer without requiring a table instance.
Definition select.hpp:501

relx::query::delete_from
auto delete_from(const Table &table)
Create a DELETE query for the specified table.
Definition delete.hpp:99

relx::query::date_diff
auto date_diff(std::string_view unit, Expr1 date1, Expr2 date2)
DATE_DIFF function - calculates difference between two dates.
Definition date.hpp:428

relx::query::coalesce
auto coalesce(First first, Second second, Rest... rest)
Create a COALESCE expression.
Definition function.hpp:409

relx::query::abs
auto abs(Expr expr)
ABS function for SQL expressions.
Definition date.hpp:833

relx::query::distinct
auto distinct(Expr expr)
Create a DISTINCT expression.
Definition function.hpp:259

relx::query::day_of_week
auto day_of_week(const T &date_column)
Get the day of week from a date (0=Sunday, 1=Monday, etc.)
Definition date.hpp:708

relx::query::val
auto val(const char *str)
Helper to create a value expression from a string literal.
Definition value.hpp:127

relx::query::now
auto now()
NOW function - alias for CURRENT_TIMESTAMP.
Definition date.hpp:552

relx::query::to_table
auto to_table(const T &table)
Helper to wrap a schema table in a table adapter.
Definition schema_adapter.hpp:94

relx::query::count_all
auto count_all()
COUNT(*) aggregate function.
Definition function.hpp:72

relx::query::on
auto on(Condition cond)
Create a join condition with the ON clause.
Definition select.hpp:43

relx::query::date_sub
auto date_sub(DateExpr date_expr, IntervalExpr interval_expr)
DATE_SUB function - subtracts an interval from a date.
Definition date.hpp:478

relx
relx database connection
Definition connection.hpp:92

operators.hpp

core.hpp

schema_adapter.hpp

select.hpp

update.hpp

value.hpp