public static Query createEditQueryById(Long id) {

    QInstanceSpecification query = QInstanceSpecification.newQuery();
    query
        .select(query.wildcard())
        .select(query.clazz().wildcard())
        .select(query.clazz().classifier().wildcard())
        .select(query.instanceCategorization().wildcard())
        .select(query.instanceCategorization().categorization().wildcard())
        .select(query.instanceCategorization().categorization().category().wildcard())
        .select(query.slot().wildcard())
        .select(query.slot().definingFeature().wildcard())
        .select(query.slot().value().wildcard())
        .select(query.slot().value().instanceValue().wildcard())
        .select(
            query.slot().value().instanceValue().instance().seqId()) // links to another instance
        .select(query.slot().value().literalString().wildcard())
        .select(query.slot().value().literalClob().wildcard())
        .select(query.slot().value().literalShort().wildcard())
        .select(query.slot().value().literalInteger().wildcard())
        .select(query.slot().value().literalLong().wildcard())
        .select(query.slot().value().literalFloat().wildcard())
        .select(query.slot().value().literalDouble().wildcard())
        .select(query.slot().value().literalDate().wildcard())
        .select(query.slot().value().literalBoolean().wildcard());
    query.where(query.seqId().eq(id));
    return query;
  }
  public static Query createExportQuery() {

    QInstanceSpecification query = QInstanceSpecification.newQuery();
    query
        .select(query.wildcard())
        .select(query.clazz().wildcard())
        .select(query.packageableType().wildcard())
        .select(query.packageableType()._package().wildcard())
        .select(query.instanceCategorization().wildcard())
        .select(query.instanceCategorization().categorization().wildcard())
        .select(query.instanceCategorization().categorization().category().wildcard());
    return query;
  }
  public static Query createDeleteQueryById(Long id) {

    QInstanceSpecification query = QInstanceSpecification.newQuery();
    query
        .select(query.seqId())
        .select(query.instanceCategorization().seqId())
        .select(query.instanceCategorization().categorization().seqId())
        // delete slots that point to us
        .select(query.instanceValue().seqId())
        .select(query.instanceValue().valueSpecification().seqId())
        .select(query.instanceValue().valueSpecification().slot().seqId())
        // delete our slots
        .select(query.slot().seqId())
        .select(query.slot().value().seqId())
        .select(query.slot().value().instanceValue().seqId())
        .select(query.slot().value().literalString().seqId())
        .select(query.slot().value().literalClob().seqId())
        .select(query.slot().value().literalShort().seqId())
        .select(query.slot().value().literalInteger().seqId())
        .select(query.slot().value().literalLong().seqId())
        .select(query.slot().value().literalFloat().seqId())
        .select(query.slot().value().literalDouble().seqId())
        .select(query.slot().value().literalDate().seqId())
        .select(query.slot().value().literalBoolean().seqId());
    query.where(query.seqId().eq(id));
    return query;
  }
  private static Query createQueueSelect(QInstanceSpecification query) {
    query
        .select(query.wildcard())
        .select(query.clazz().wildcard())
        .select(query.clazz().classifier().wildcard())
        .select(query.instanceCategorization().wildcard())
        .select(query.instanceCategorization().categorization().wildcard())
        .select(query.instanceCategorization().categorization().category().name())
        .select(query.instanceCategorization().categorization().category().parent().name())
        .select(query.slot().wildcard())
        .select(query.slot().definingFeature().wildcard())
        .select(query.slot().definingFeature().name())
        .select(query.slot().value().wildcard())
        .select(query.slot().value().literalString().value())
        .select(query.slot().value().literalClob().value())
        .select(query.slot().value().literalShort().value())
        .select(query.slot().value().literalInteger().value())
        .select(query.slot().value().literalLong().value())
        .select(query.slot().value().literalFloat().value())
        .select(query.slot().value().literalDouble().value())
        .select(query.slot().value().literalDate().value())
        .select(query.slot().value().literalBoolean().value())

        // all this to resolve the instance value to some readable string
        .select(query.slot().value().instanceValue().seqId())
        .select(
            query.slot().value().instanceValue().instance().seqId()) // links to another instance
        .select(query.slot().value().instanceValue().instance().clazz().seqId())
        .select(query.slot().value().instanceValue().instance().clazz().classifier().name())
        .select(query.slot().value().instanceValue().instance().clazz().classifier().seqId())
        .select(query.slot().value().instanceValue().instance().slot().wildcard())
        .select(query.slot().value().instanceValue().instance().slot().definingFeature().seqId())
        .select(query.slot().value().instanceValue().instance().slot().definingFeature().name())
        .select(query.slot().value().instanceValue().instance().slot().value().wildcard())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalString().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalClob().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalShort().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalInteger().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalLong().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalFloat().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalDouble().value())
        .select(
            query.slot().value().instanceValue().instance().slot().value().literalDate().value())
        .select(
            query
                .slot()
                .value()
                .instanceValue()
                .instance()
                .slot()
                .value()
                .literalBoolean()
                .value());
    return query;
  }