I have no issues with emergency skills, accents/descents and am apparently super relaxed and clam about things.The information in this thread is correct. You need to have been taught the emergency swimming accent, but it is the instructor's discretion as to what skills you must perform in open water.
Many SDI do not do require students to perform that skill in open water. I generally don't. You can go to tdi/sdi and talk with someone from HQ during chat. I'd also say that if you feel like you need more work on that skill and you shouldn't have been certified, a discussion with the shop would be prudent.

I was more less concerned with navigation and was expecting at least a basic in-water skills learning with a compass, PDC or at least dive tables. I’m told by the local sdi dive DS they aren’t covered until the advance course. We briefly discussed dive tables, use of compass and PDC in an in classroom discussion setting but there is no in water learning of navigation, dive computer, compass or dive tables. I just thought we would be touching on it in water during the open water. Especially given the SSI/SDI route seem to highlight they are tech driven in learning.

@Marie13 left linked the sdi open water outcomes in another comment and I’m copping the link to that here. Page 6/8 (#13 and #18) sounds like it’s suppose to be covered but maybe they just mean in the classroom and not in water?
https://www.tdisdi.com/wp-content/uploads/files/sandp/currentYear/SDI/part 2/pdf/individual/SDI Diver Standards_07_Open_Water_Scuba_Diver.pdf
I’ll contact HQ but am curious what kinda in water navigation skills were coverage in other peoples open water be it PADI, SDI or SSI