Yes, in most cases you should be able to open your dining room table with extension leaves on your own regardless of whether you own a model with click catch or align-n-lock leaf.
However, if you suffer from back pain or have reduced mobility, it’d probably be wiser to ask for help.