SqlExp C++
|
PostgreSQL
|
Select(COLUMN)
.From(TABLE)
|
select COLUMN
from TABLE
|
Select(COLUMN.Of(TABLE))
.From(TABLE)
|
select TABLE.COLUMN
from TABLE
|
Select(COLUMN.As(A))
.From(TABLE)
|
select COLUMN as A
from TABLE
|
Select(COLUMN&A)
.From(TABLE)
|
select COLUMN$A
from TABLE
|
Select(COLUMN[3])
.From(TABLE)
|
select COLUMN3
from TABLE
|
Select(COLUMN1 % COLUMN2)
.From(TABLE)
|
select mod(COLUMN1, COLUMN2)
from TABLE
|
Select(COLUMN1 | COLUMN2)
.From(TABLE)
|
select COLUMN1 || COLUMN2
from TABLE
|
Select(SqlFunc("any_fn", COLUMN, 2))
.From(TABLE)
|
select any_fn(COLUMN, 2)
from TABLE
|
Select(SqlTxt("current_time"))
.From(TABLE1)
|
select current_time
from TABLE1
|
Select(Distinct(COLUMN))
.From(TABLE)
|
select distinct COLUMN
from TABLE
|
Select(Distinct(SqlSet(COLUMN1, COLUMN2)))
.From(TABLE)
|
select distinct COLUMN1, COLUMN2
from TABLE
|
Select(All(COLUMN))
.From(TABLE)
|
select all COLUMN
from TABLE
|
Select(Count(COLUMN))
.From(TABLE)
|
select count(COLUMN)
from TABLE
|
Select(SqlAll())
.From(TABLE)
|
select *
from TABLE
|
Select(SqlCountRows())
.From(TABLE)
|
select count(*)
from TABLE
|
Select(COLUMN)
.From(TABLE)
.OrderBy(Descending(COLUMN))
|
select COLUMN
from TABLE
order by COLUMN desc
|
Select(SqlMax(COLUMN))
.From(TABLE)
|
select max(COLUMN)
from TABLE
|
Select(SqlMin(COLUMN))
.From(TABLE)
|
select min(COLUMN)
from TABLE
|
Select(SqlSum(COLUMN))
.From(TABLE)
|
select sum(COLUMN)
from TABLE
|
Select(Avg(COLUMN))
.From(TABLE)
|
select avg(COLUMN)
from TABLE
|
Select(Stddev(COLUMN))
.From(TABLE)
|
select stddev(COLUMN)
from TABLE
|
Select(Variance(COLUMN))
.From(TABLE)
|
select variance(COLUMN)
from TABLE
|
Select(Greatest(COLUMN1, COLUMN2))
.From(TABLE)
|
select greatest(COLUMN1, COLUMN2)
from TABLE
|
Select(Least(COLUMN1, COLUMN2))
.From(TABLE)
|
select least(COLUMN1, COLUMN2)
from TABLE
|
Select(Upper(COLUMN))
.From(TABLE)
|
select upper(COLUMN)
from TABLE
|
Select(Lower(COLUMN))
.From(TABLE)
|
select lower(COLUMN)
from TABLE
|
Select(Substr(COLUMN, 1))
.From(TABLE)
|
select SUBSTR(COLUMN, 1)
from TABLE
|
Select(Substr(COLUMN, 2, 1))
.From(TABLE)
|
select SUBSTR(COLUMN, 2, 1)
from TABLE
|
Select(Instr(COLUMN, "hello"))
.From(TABLE)
|
select INSTR(COLUMN, 'hello')
from TABLE
|
Select(SqlNvl(COLUMN1, COLUMN2))
.From(TABLE)
|
select coalesce(COLUMN1, COLUMN2)
from TABLE
|
Select(NextVal(SEQ)).Get()
|
select nextval('SEQ')
|
Select(CurrVal(SEQ)).Get()
|
select currval('SEQ')
|
Select(SqlArg())
.From(TABLE)
|
select ?
from TABLE
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN / 2 > 1 && COLUMN1 == "A" ||
COLUMN2 == Date(2006, 1, 1))
|
select COLUMN
from TABLE
where COLUMN / 2 > 1 and COLUMN1 = 'A' or COLUMN2 = '2006-01-01'
|
Select(COLUMN)
.From(TABLE)
.Where(!(COLUMN == 1))
|
select COLUMN
from TABLE
where not (COLUMN = 1)
|
Select(COLUMN)
.From(TABLE)
.Where((COLUMN1 == 1) - (COLUMN2 == 1))
|
select COLUMN
from TABLE
where COLUMN1 = 1 and not COLUMN2 = 1
|
Select(COLUMN)
.From(TABLE)
.Where(IsNull(COLUMN1))
|
select COLUMN
from TABLE
where COLUMN1 is NULL
|
Select(COLUMN)
.From(TABLE)
.Where(NotNull(COLUMN1))
|
select COLUMN
from TABLE
where COLUMN1 is not NULL
|
Select(COLUMN)
.From(TABLE)
.Where(Like(COLUMN1, Wild("A*")))
|
select COLUMN
from TABLE
where COLUMN1 like 'A%%'
|
Select(COLUMN)
.From(TABLE)
.Where(NotLike(COLUMN1, Wild("A*")))
|
select COLUMN
from TABLE
where COLUMN1 not like 'A%%'
|
Select(COLUMN)
.From(TABLE)
.Where(In(COLUMN, Select(COLUMN).From(TABLE1)))
|
select COLUMN
from TABLE
where COLUMN in (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == Select(COLUMN).From(TABLE1))
|
select COLUMN
from TABLE
where COLUMN in (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(TABLE)
.Where(NotIn(COLUMN,
Select(COLUMN).From(TABLE1)))
|
select COLUMN
from TABLE
where COLUMN not in (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN != Select(COLUMN).From(TABLE1))
|
select COLUMN
from TABLE
where COLUMN not in (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(TABLE)
.Where(Exists(Select(COLUMN).From(TABLE1)))
|
select COLUMN
from TABLE
where exists (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(TABLE)
.Where(NotExists(Select(COLUMN).From(TABLE1)))
|
select COLUMN
from TABLE
where not exists (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == (Select(COLUMN1).From(TABLE1) |
Select(COLUMN2).From(TABLE2)))
|
select COLUMN
from TABLE
where COLUMN in (select COLUMN1 from TABLE1
union (select COLUMN2 from TABLE2))
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == (Select(COLUMN1).From(TABLE1) &
Select(COLUMN2).From(TABLE2)))
|
select COLUMN
from TABLE
where COLUMN in (select COLUMN1 from TABLE1
intersect (select COLUMN2 from TABLE2))
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == (Select(COLUMN1).From(TABLE1) -
Select(COLUMN2).From(TABLE2)))
|
select COLUMN
from TABLE
where COLUMN in (select COLUMN1 from TABLE1
minus (select COLUMN2 from TABLE2))
|
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == 0)
.GroupBy(COLUMN)
.Having(COLUMN1 == 0)
.OrderBy(Descending(COLUMN))
|
select COLUMN
from TABLE
where COLUMN = 0
group by COLUMN
having COLUMN1 = 0
order by COLUMN desc
|
Select(COLUMN)
.From(TABLE).Limit(100)
|
select COLUMN
from TABLE limit 100
|
Select(COLUMN)
.From(TABLE).Limit(100, 10)
|
select COLUMN
from TABLE limit 100, 10
|
Select(COLUMN)
.From(TABLE).Offset(20)
|
select COLUMN
from TABLE offset 20
|
Select(850).Get()
|
select 850
|
Select(COLUMN)
.From(TABLE).Hint("hint")
|
/*+ hint */ select COLUMN
from TABLE
|
Select(COLUMN)
.From(TABLE)
.InnerJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
|
select COLUMN
from TABLE
inner join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
|
Select(COLUMN)
.From(TABLE)
.LeftJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
|
select COLUMN
from TABLE
left outer join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
|
Select(COLUMN)
.From(TABLE)
.RightJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
|
select COLUMN
from TABLE
right outer join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
|
Select(COLUMN)
.From(TABLE)
.FullJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
|
select COLUMN
from TABLE
full outer join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
|
Delete(TABLE)
.Where(COLUMN < 0)
|
delete
from TABLE
where COLUMN < 0
|
Insert(TABLE)
(COLUMN1, 12)
(COLUMN2, "hello")
(COLUMN, Date(2007, 1, 1))
|
insert into TABLE(COLUMN1, COLUMN2, COLUMN)
values (12, 'hello', '2007-01-01')
|
Insert(TABLE)(COLUMN1, 12)(COLUMN2)(COLUMN)
.From(TABLE1)
.Where(COLUMN >= 0)
|
insert into TABLE(COLUMN1, COLUMN2, COLUMN)
select 12, COLUMN2, COLUMN
from TABLE1
where COLUMN >= 0
|
Update(TABLE)
(COLUMN1, 13)
(COLUMN2, "world")
.Where(COLUMN > Date(2007, 1, 1))
|
update TABLE
set COLUMN1 = 13, COLUMN2 = 'world'
where COLUMN > '2007-01-01'
|
Insert(TABLE)(COLUMN, Select(COLUMN1)
.From(TABLE1)
.Where(COLUMN2 == 21).AsValue())
|
insert into TABLE(COLUMN) values ((select
COLUMN1
from TABLE1
where COLUMN2 = 21))
|
Select(COLUMN)
.From(Select(COLUMN).From(TABLE1))
|
select COLUMN
from (select COLUMN from TABLE1)
|
Select(COLUMN)
.From(Select(COLUMN).From(TABLE1)
.AsTable(TABLE2))
|
select COLUMN
from ((select COLUMN from TABLE1) as TABLE2)
|
Select(COLUMN)
.From(TABLE)
.LeftJoin(Select(COLUMN).From(TABLE1))
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
|
select COLUMN
from TABLE left outer join
(select COLUMN from TABLE1)
on TABLE.COLUMN = TABLE1.COLUMN1
|
Select(COLUMN)
.From(TABLE)
.LeftJoin(Select(COLUMN).From(TABLE1)
.AsTable(TABLE2))
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
|
select COLUMN
from TABLE
left outer join
((select COLUMN from TABLE1) as TABLE2)
on TABLE.COLUMN = TABLE1.COLUMN1
|
Select(TABLE(COLUMN, COLUMN1)).From(TABLE)
|
select TABLE.COLUMN, TABLE.COLUMN1 from TABLE
|
Select(ID(ID, NAME, LASTNAME))
.From(TABLE1).LeftJoinRef(TABLE2)
.Where(BDATE == Date(2011, 12, 9))
|
select ID.ID, ID.NAME, ID.LASTNAME
from TABLE1 left outer join TABLE2
on TABLE2.TABLE1_ID = TABLE1.NAME
where BDATE = date '2011-12-09'
Note: Based on .sch file REFERENCES
|
Select(ID(ID, NAME, LASTNAME))
.From(TABLE1).LeftJoinRef(TABLE2)
.On(IsNull(BDATE))
.Where(BDATE == Date(2011, 12, 9))
|
select ID.ID, ID.NAME, ID.LASTNAME
from TABLE1 left outer join TABLE2
on TABLE2.TABLE1_ID = TABLE1.NAME
and BDATE is NULL
where BDATE = date '2011-12-09'
Note: Based on .sch file REFERENCES
|
Select(TABLE1(SqlAll()))
.From(TABLE1)
|
select TABLE1.* from TABLE1
|
Select(SqlAll().Of(TABLE1))
.From(TABLE1)
|
select TABLE1.* from TABLE1
|
Vector<int> m;
...
Select(ID)
.From(TABLE1)
.Where(ID == SqlSetFrom(m))
|
select ID
from TABLE1
where ID in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9)
|
