nawk -F'|' -v Q="'" '
{
    req       = $1;
    table     = $3;
    column    = $4;
    attribute = $5;
    nbTbl     = ++Requests[req];     # Tables count
    Tables[req, nbTbl]     = table;
    Columns[req, nbTbl]    = column;
    Attributes[req, nbTbl] = attribute;
}
END {
    tblIds = "abcdefghijklmnopqrstuvwxyz";
    for (req in Requests) {
        nbTbl  = Requests[req]
        select = "";
        where  = "";
        from   = "";
        sep    = "";
        for (i=1; i<=nbTbl; i++) {
            id        = substr(tblIds,i,1);
            select    = select sep id "." Columns[req, i];
            from      = from   sep Tables[req, i] " " id;     
            attribute = Attributes[req, i];
            if (attribute ~ /[*%]/) {
                not = "";
                if (substr(attribute,1,1) == "!") {
                    not = "NOT ";
                    attribute = substr(attribute,2);
                }
                where = where (sep ? " and " : "") id "." Columns[req, i] " " not "LIKE " Q attribute Q;
            } else {
                where = where (sep ? " and " : "") id "." Columns[req, i] "=" Q attribute Q;
            }
            sep = ",";
            }
        print "\nselect",select,"\nfrom  ",from,"\nwhere ",where,";";
    }
}
' inputfile

R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20|
R1|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.20|8533.10.00.20|
R4|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|THROUGH HOLE MOUNT|AND|8533.10.00.57|8533.10.00.57|
R4|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.57|8533.10.00.57|
R7|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.21.00.10|8533.21.00.25|
R7|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|!CARBON*|AND|8533.21.00.10|8533.21.00.25|
R7|Array/Network Resistor - VIP|V_PRT_CLASS|V_MFR_PKG_DESC|DIP*||8533.21.00.10|8533.21.00.25|

select a.V_MOUNT_FEATURE,b.V_TECHNOLOGY
from   V_RES_CLASS a,V_RES_NW_CLASS b
where  a.V_MOUNT_FEATURE='SURFACE MOUNT' and b.V_TECHNOLOGY LIKE 'CARBON*' ;

select a.V_MOUNT_FEATURE,b.V_TECHNOLOGY
from   V_RES_CLASS a,V_RES_NW_CLASS b
where  a.V_MOUNT_FEATURE='THROUGH HOLE MOUNT' and b.V_TECHNOLOGY LIKE 'CARBON*' ;

select a.V_MOUNT_FEATURE,b.V_TECHNOLOGY,c.V_MFR_PKG_DESC
from   V_RES_CLASS a,V_RES_NW_CLASS b,V_PRT_CLASS c
where  a.V_MOUNT_FEATURE='SURFACE MOUNT' and b.V_TECHNOLOGY NOT LIKE 'CARBON*' and c.V_MFR_PKG_DESC LIKE 'DIP*' ;