Person person = new Person();
        // join будет только тогда, когда поле из этой таблице будет использовано в других секциях
        PersonMove innerPersonMove = person.person_id.innerPersonMove(); // здесь идет inner Join нужно для where
        PersonMove leftPersonMove = person.person_id.leftPersonMove();// здесь идет left Join нужно для select

        // фильтры
        if (filterCurrentData) innerPersonMove.where(innerPersonMove.move_date.eq(param(new Date(System.currentTimeMillis()))));
        if (fromDepId!=null) innerPersonMove.where(innerPersonMove.from_dep_id.eq(param(fromDepId)));
        if (personId!=null) person.where(person.person_id.eq(param(personId)));

        Select select = new PostgresSelect();
        select.select(person.first_name);
        select.select(person.last_name);
        // здесь идет inline join
        if (showPersonType) select.select(person.person_type_id.innerPersonType().person_type_name);

        // при чем можем соединять несколько раз, в итоге все равно будет только один Join
        if (showPersonType) select.select(person.person_type_id.innerPersonType().person_type_id);

        // считаем count, секция group by автоматически заполнится
        if (showCountMove) select.select(count(leftPersonMove.person_move_id).as("person_move_cnt"));

        // результаты для разных параметров
        ....
        boolean filterCurrentData = false;
        boolean showCountMove = false;
        boolean showPersonType = false;
        Short fromDepId = null;
        Integer personId = null;

        out >> select t0.first_name,t0.last_name from public.person t0

        ....
        boolean filterCurrentData = true;
        boolean showCountMove = false;
        boolean showPersonType = false;
        Short fromDepId = null;
        Integer personId = null;

        out >> select t0.first_name,t0.last_name 
                   from public.person t0 
                   inner join public.person_move t1 on t0.person_id = t1.person_id and t1.move_date = ?

        ....
        boolean filterCurrentData = true;
        boolean showCountMove = true;
        boolean showPersonType = false;
        Short fromDepId = null;
        Integer personId = null;

        out >> select t0.first_name,t0.last_name,count(t2.person_move_id) as person_move_cnt 
                  from public.person t0 
                      inner join public.person_move t1 on t0.person_id = t1.person_id and t1.move_date = ? 
                      left join public.person_move t2 on t0.person_id = t2.person_id 
                  group by t0.first_name,t0.last_name


        ....
        boolean filterCurrentData = true;
        boolean showCountMove = true;
        boolean showPersonType = true;
        Short fromDepId = null;
        Integer personId = null;

        out >> select t0.first_name,t0.last_name,t2.person_type_name,t2.person_type_id,count(t3.person_move_id) as person_move_cnt 
                  from public.person t0 
                  inner join public.person_move t1 on t0.person_id = t1.person_id and t1.move_date = ? 
                  inner join public.person_type t2 on t0.person_type_id = t2.person_type_id 
                  left join public.person_move t3 on t0.person_id = t3.person_id 
                  group by t0.first_name,t0.last_name,t2.person_type_name,t2.person_type_id


        ....
        boolean filterCurrentData = true;
        boolean showCountMove = true;
        boolean showPersonType = true;
        Short fromDepId = 123;
        Integer personId = 456;

        out >> select t0.first_name,t0.last_name,t2.person_type_name,t2.person_type_id,count(t3.person_move_id) as person_move_cnt 
                  from public.person t0 
                  inner join public.person_move t1 on t0.person_id = t1.person_id and t1.move_date = ? and t1.from_dep_id = ? 
                  inner join public.person_type t2 on t0.person_type_id = t2.person_type_id 
                  left join public.person_move t3 on t0.person_id = t3.person_id 
                  where t0.person_id = ? 
                  group by t0.first_name,t0.last_name,t2.person_type_name,t2.person_type_id

        final UColumn uColumn = new UColumn();
        final BrRecord brRecord;
        Integer searchBrId = brId != -1 ? brId : linkBrId;

        if (linkBrId!=-1 && brLinkTypeId!=-1) {
            final BrLinkTypeMap brLinkTypeMap = uColumn.U_COLUMN_CODE.innerBrLinkTypeMapByChildCode();
            brLinkTypeMap.where(brLinkTypeMap.BR_LINK_TYPE_ID, Criteria.EQ, brLinkTypeId);
            brLinkTypeMap.where(brLinkTypeMap.CHILD_DESC_LEVEL_ID, Criteria.EQ, descLevelId);
            brRecord = brLinkTypeMap.PARENT_CODE.innerUColumn().U_COLUMN_CODE.innerBrRecord();
        } else {
            brRecord = uColumn.U_COLUMN_CODE.innerBrRecord();
        }
        brRecord.where(brRecord.BR_ID, Criteria.EQ, searchBrId);

        class BrRecordData extends Select {
            public BrRecordData() { super(uColumn,true);}
            final ViewColumn<BrRecordData,String> U_FIELD_CODE = new ViewColumn<BrRecordData, String>(this,uColumn.U_FIELD_CODE);
            final ViewColumn<BrRecordData,Integer> FIELD_NUM = new ViewColumn<BrRecordData, Integer>(this,brRecord.FIELD_NUM);
        }

        final WorkList workList = new WorkList();
        workList.where(workList.DESC_LEVEL_ID, Criteria.EQ, descLevelId);
        workList.where(workList.DESC_TYPE_ID, Criteria.EQ, descTypeId);
        workList.where(fullView ? workList.IS_BR :workList.IS_PRIMARYBR , Criteria.EQ, (short) 1);

        final UField uField = workList.WORK_LIST_ID.innerWorkListColumn().U_COLUMN_CODE.innerUColumn().U_FIELD_CODE.innerUField();
        final BrRecordData brRecordData = uField.join(JoinType.left, uField.U_FIELD_CODE, new BrRecordData().U_FIELD_CODE);

        Select select = new Select(workList,true);

        select.select(uField.U_FIELD_CODE);
        select.select(uField.U_FIELD_NAME);
        select.select(uField.ISREPEATABLE);
        select.select(coalesce(brRecordData.FIELD_NUM,-1).as("FIELD_NUM"));

        SelectSQL sql = select.getSQL(new AliasGenerator());

SELECT DISTINCT
  t3.U_FIELD_CODE           AS U_FIELD_CODE,
  t3.U_FIELD_NAME           AS U_FIELD_NAME,
  t3.ISREPEATABLE           AS ISREPEATABLE,
  coalesce(t4.FIELD_NUM, ?) AS FIELD_NUM
FROM NABRK.WORK_LIST t0 
  INNER JOIN NABRK.WORK_LIST_COLUMN t1 
    INNER JOIN NABRK.U_COLUMN t2 
      INNER JOIN NABRK.U_FIELD t3 
        LEFT JOIN (SELECT DISTINCT
                    t5.U_FIELD_CODE AS U_FIELD_CODE,
                    t6.FIELD_NUM    AS FIELD_NUM
                  FROM
                    NABRK.U_COLUMN t5 INNER JOIN
                    NABRK.BR_RECORD t6 ON t5.U_COLUMN_CODE = t6.U_COLUMN_CODE AND t6.BR_ID = ?) t4
        ON t3.U_FIELD_CODE = t4.U_FIELD_CODE 
      ON t2.U_FIELD_CODE = t3.U_FIELD_CODE 
    ON t1.U_COLUMN_CODE = t2.U_COLUMN_CODE
  ON t0.WORK_LIST_ID = t1.WORK_LIST_ID
WHERE t0.DESC_LEVEL_ID = ? AND t0.DESC_TYPE_ID = ? AND t0.IS_BR = ?