Does anyone have a very basic example of how I can integrate a SQL statement in to a script?

I've run into plenty of occasions where I wish I knew how to accomplish this, here is my current goal:

We ship using Starship and for a variety of reasons I created a UDF_Quantity_To_Ship field and some scripts based around it to make it work the way we need. I am attempting to bring that information on to the Item Maintenance/Item Inquiry screens. I would like to, for instance, be able to sum the quantity to ship field for an item if the picking sheet has been printed. I can accomplish this easily in Access but it would make the lives of my users a lot easier if I was able to show this information on the Item screens. Thoughts?