Thank you Nancy! So one of my friends suggested not using a drum shade fixture as it would block the view. Any other suggestions? Should I go with something modern to contrast the sweetness of the table? I like a casua, cozy vibe, not stuffy or too elegant.

I like the drum shade fixture a lot and don't think it blocks view.

like any of these?

Beth, I like the woven one best!

Nancy Ingram, could you photoshop these two black light fixtures too please?

Here you go!

What do ya’ll think? Black or white/neutral color? I like the drama the black adds

I don’t like the tapered drum I think a large simple drum shade might work . BTW in a DR the shade should be hung at approx bottom of shade 30” from table top and since you will be seated in the space the view will not be hampered.I would like to see a bit of the rest of the home decor this is not decided in a vacuum. IMO you could do an oversized drum shade but I need some context, I find the chairs a bit on the light weight side for such a heavy table too.

Not a Pro.

Pick lighting last.

I think those drum shades with all the wires look dumb. I like your original fixture....but hang it lower.
Realize that a solid shade will "focus" the light and allow less ambient light in the rest of the room. You may find that it gives your room a less casual feel and more of a restaurant feel.
What a light fixture looks like in the day time can be very different than that same fixture, lit, in a dark room.