Something like SQL Functions

By João Fonseca on 28 Jun 2011
Focusing on SQL Table-value Functions. Something that will be similar to an Entity (to be used on Simple and Advance Queries) but the data is returned from an action or query.

Example1. When having hierarchies it's useful to centralize their structure in one query and then use it to join other tables, avoid cycles with 2,3 or 4 queries in each iteration.

Example2. When we have user info in n extended tables (USER, USER_EXT1, ...) we would like to return user info at once avoiding joining extended tables in each query that we have to make.
Fernando Sousa29 Jun 2011
Regarding queries, could this be accomplished by Creating and using Views?
João Fonseca30 Jun 2011
Fernando, yes but, a view created in Service Studio. Instead of create on sql, add to an extension and then consume it.