What's the purpose of the lamps? For actual lighting? For aesthetics?

IMO lamps don't belong on a dining room table. Candles, sure, but do you really want your home to feel like a restaurant?

Lamps on dining room table do not belong in homes. Would recommend a pendent or chandelier. Do you have a picture of your space and size of your dining table? That might give us a better idea to help you.

Do not put lamps on your dining table, that would look absolutely ridiculous. Dining rooms have overhead chandelier lighting. If you want your home to be more like a restaurant, take a cooking class.

Could you maybe show the space and also why you don’t or can’t have a chandeleir.

Our dining area is part of a great room and the ceiling lights don't match up with where we put our table. So, I'm thinking lights on the table would be very cool.

I'm not sure where you would find small non electric lamps but would something like this work?

LED bulb / W 5.12" / H 11" / Black Aluminum

Circleware Birdcage Metal Lamp - Cordless Accent Light with LED Bulb - 11" H · More Info

[https://www.houzz.com/products/circleware-birdcage-metal-lamp-cordless-accent-light-with-led-bulb-11-prvw-vr~116464645[(https://www.houzz.com/products/circleware-birdcage-metal-lamp-cordless-accent-light-with-led-bulb-11-prvw-vr~116464645)