I'd suggest just changing the 2 hand pierce items into 1 hand pierce items in your database it's fairly trivial to do so. Though you'd be able to still DW so might want to scale back item stats to reflect that for balance purposes. It would give you the achieved visual appearance your seeking and even allow for a 2H weapon + a shield.
In fact I even at one point made a SQL file where I turned all the 2H weapons and converted them into 1H equip versions of the same items. They have different custom ID #'s as well so no need to worry about them overwriting the original versions.
http://www.eqemulator.org/forums/showthread.php?t=38271
http://i127.photobucket.com/albums/p...psbfd95129.jpg
http://i127.photobucket.com/albums/p...ps6b9f8c06.jpg