Application: gvSIG desktop

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.fmap.dal.SQLBuilder;

    @Override

    public ExpressionBuilder.Value toValue(ExpressionBuilder builder, Codes args) {

        try {

            SQLBuilder sqlBuilder = (SQLBuilder) builder.getProperty("SQLBUILDER");

            if(sqlBuilder == null){

                return super.toValue(builder, args);

            }

            SQLBuilder.SelectBuilder select = sqlBuilder.createSelectBuilder();

            String storeName = this.getTableName(args, TABLE);

            Callable columns = getTupleOrNull(args, COLUMNS);

            Code where = this.getWhereCode(args, WHERE);

            Callable order = getTupleOrNull(args, ORDER);

            Callable order_mode = getTupleOrNull(args, ORDER_MODE);

            Code limit = args.get(LIMIT);

            if (storeName != null) {

                select.from().table().name(storeName);

            }

            if (columns != null) {

                for (Code column : columns.parameters()) {

                    if (column instanceof Code.Identifier) {

                        select.column().name(

                                select.from().table(),

                                ((Code.Identifier) column).name()

                        );

                    }

                }

            }

            if (where != null) {

                select.where().value(where.toValue(builder));

            }

            if (limit != null) {

                select.limit(((Number) ((Code.Constant) limit).value()).longValue());

            }

            if (order != null || order_mode != null) {

                for (int n = 0; n < order.parameters().size(); n++) {

                    Code member = order.parameters().get(n);

                    Code.Constant mode = (Code.Constant) order_mode.parameters().get(n);

                    select.order_by().value(member.toValue(builder)).ascending((boolean) mode.value());

                }

            }

            return select;

        } catch (Exception ex) {

            return super.toValue(builder, args);

        }

    }