Hi Jay,
With only a few minutes into Blockly, this may be an advanced move. That being said, you can see (and edit) the code for the logic_compare block in blocks/logic.js at about line 275. There, you can add a "between" selection.
The mutator is the advanced part. In blocks/lists.js, the lists_getIndex block has a mutator for adding a removing an input block that you can duplicate. The mutationToDom and domToMutation are the important bits. The updateAt_ in domToMutation is the bit where the extra input is added or deleted.
Beyond that, I don't know what you're doing with the actual input-- output to code, interpreted as sql, etc. Whatever that is will need to be able to interpret the new block structure correctly.
Cheers,
Daaron