4 ms·
Take a single line from my example 'x.relation.relation.relation.value' The SQL would be select w.value from x join y on y.relation=x.relation join z
by bottlepalm 4y ago
Take a single line from my example 'x.relation.relation.relation.value'
The SQL would be
select w.value
from x
join y on y.relation=x.relation
join z on z.relation=y.relation
join w on w.relation=z.relation
1 line for the ORM, 5 lines of SQL. Please give an example where the SQL is less than what I typed in the previous comment.
In addition compiling will validate the ORM code generates valid SQL. On the other hand compiling will not validate a SQL string.
'Custom functions' are just larger versions of the anonymous functions in my example. Very easy for other developers to go to the reference and understand.