Application: gvSIG desktop

    public String format(Value function0) {

        Function function = (Function) function0;

        String tableName = (String) function.parameters().get(TABLE).toString(formatter);

        Value where = function.parameters().get(WHERE);

        Value order = function.parameters().get(ORDER);

        Value limit = function.parameters().get(LIMIT);

        Value order_mode = function.parameters().get(ORDER_MODE);

        StringBuilder builder = new StringBuilder();

        builder.append("(SELECT ");

        try {

            Value c = function.parameters().get(COLUMNS);

            if (c instanceof ExpressionBuilder.Variable) {

                builder.append('"');

                builder.append(((ExpressionBuilder.Variable)c).name());

                builder.append("\" ");

            } else {

                Function columns = (Function) c;

                if (!StringUtils.equalsIgnoreCase(((ExpressionBuilder.Function) columns).name(), FUNCTION_TUPLE)) {

                    throw new IllegalArgumentException();

                }

                if (columns.parameters().isEmpty()) {

                    builder.append("* ");

                } else {

                    boolean needcomma = false;

                    for (Value parameter : columns.parameters()) {

                        if (needcomma) {

                            builder.append(", ");

                        } else {

                            needcomma = true;

                        }

                        builder.append(parameter.toString(formatter));

                    }

                }

            }

        } catch (Exception ex) {

            throw new IllegalArgumentException("Invalid columns, need a tuple function as columns.");

        builder.append(" FROM ");

        builder.append(tableName);

        if (where != null) {

            builder.append(" WHERE ");

            builder.append(where.toString(formatter));

        }

        if (limit != null) {

            builder.append(" LIMIT ");

            builder.append(limit.toString(formatter));

        }

        builder.append(")");

        return builder.toString();