Finding Sisqo, a writers quest

Deep Space Nine is my favorite Star Trek show, even above the original series and my second favorite is Discovery. So my biases are on the table. 
Now, if someone said to me, Rich, we want a show to find Captain Sisqó. 
My first thoughts will be what do I know about Captain Sisqó's departure. I know who: sisqo, when: stardate given, where:the prophet temple , what: fought gul ducat and negative entities, how: joined prophets , why: prophecy, it was foretold. Last but not least, Sisqó himself said he would return to be with his family: Jake + Cassidy. 
Second, what don't I know? 
Any clues or definition of when Sisqó would return. Which means I need to figure four things: 
1) when sisqo returned to Jake+ Cassidy, who was pregnant when he left, and what did they do.
2) why did Sisqó have to leave again after returning to Jake+ Cassidy
3) what role does the prophets or the Q have with that eden like place found in star trek discovery.
4) when will sisqo be found in the context of Star  Trek Starfleet Academy
Third, where should anyone in Star Trek Starfleet Academy begin to search for Sisqó? 
The answer in my mind is obvious with all the players of Deep Space Nine.
Jake- he will see his father as an older man[ rest in peace Tony Todd] , but that will not be the Prophet Sisqó so to speak, and that Jake while surprised didn't seem like he was waiting for Sisqo then. so, writers have work to do, but have one clue which keeps star trek's timeline together. Michael Burnham's husband can find Jake's writings. If they can find a VHS tape of Fae Valentine's old self, anything is possible. Yes, non star trek but, data storage of writings should be findable.
Cassidy- she was pregnant, she had to live to when Sisqó would see her again. But that doesn't mean after that moment when he went missing again, she was the same. 
For Jake+ Cassidy Star Trek offers some convenient tools. They can leap through time in cryogenic tubes, khan noonian singh does it all the time. Scotty survived in a transfer buffer for decades. So tools exist to leap frog Cassidy or Jake, especially through the fall of the federation, which keeps Discovery's continuity. 
Dax - is a trill and Dax can still be alive, even though the trills have gone through challenges, so maybe Dax is dead or maybe Dax is so old the old identities are silent. Dax needs to be spoken to.
Dr Bashir-  he was genetic modified so I am not certain he has to be dead. And he wasn't in hiding when the show ended and had relations with other genetic modified doing various calculations or activities.  All his work or notes over the years need to be researched or found. 
Major Kira- what is the status of Bajor? based on discovery, it is unknown to the audience cause the federation diminished in size and was near death as an organization. so, Bajor is changed. But where does that put Bajorans? Got to go to Bajor and see if any priests or priestess have anything, the ki's right?
The prophets - they need to be talked to, if any will know they will. If their gateway is still the wormhole outside Bajor well. got to talk to them.
Odo- He was changling, changling do die and get old , but changlings can survive a long time and last we saw him he was in the collective to heal them. With the Jim hadar,/Klingon guy, maybe he may be able to ask someone. Odo needs to be found and it connects to Kira, whom I can't imagine didn't see Odo again before she died. 
Worf- His sone Alexander is going to become , through Voyager, a Klingon scientist who discovers how to time travel. How did he do that? That can be useful. Even considering the fall of the federation, where did Alexander go?
Chief Obrian- He is one of the few crew members who I can't see a connection to getting a clue for Sisqó. He left back for earth. The one thing I will suggest is, he was a transporter operator in next generation before becoming a chief so maybe he had an event in the annals of the federation. 
Quark- A ferengi, Quark was one of the characters always on the lookout for the others. The ferengi may be greedy but the ferengi travel, gossip, hear whispers, the great river, his nephew Nog, rest that actors soul, and his brother was a genius. So, Maybe Quark made a record of something, heard something and placed it in the financial records. I imagine ferengi's keep their taxes for a long time and with the fall of the federation and growth of the Orion's I can see Ferengi's doing generally well. 
Vic- the 1950s bar program on deep space nine. Like the Doctor of Voyager who seems to be a character in Academy, the bar program is long lived , as long as it has enough memory and where it is stored  isn't damaged by nanites or violence. Vic as a resident of deep space nine and a popular bar will have privy to a long list of gossips or information. It is worth a search.
NOTE: To bad the section 31 guy in Deep Space Nine passed away because based on Michelle Yeoh's time with them, I bet they know something. 

So... The idea of finding Sisqó is fine on the surface. Deep Space Nine , if they will respect it, gave the general outline. 
1)Sisqó left at the end of Deep space nine.
2) Stuff happened.
3) sisqo returned to Jake + Cassidy + the new child older
4) Sisqó left again for some reason
5) stuff happened
6) Sisqó is found somewhere, whether it be foretold or prophecy or because of a negative agent. 

2 or 5 is where you can fill the blanks with a lot. 

FORUM POST

https://aalbc.com/tc/topic/12434-writer-a-producer-for-skydance-said-they-want-to-find-sisqo-in-the-new-show-star-trek-starfleet-academy-what-say-you/

IN AMENDMENTS

02042026

From a story perspective I have a lot to say, but I will take one angle I didn't mention elsewhere on this topic.... legends don't happen because of the past, England has many mythological old kings, why does arthur matter more than many others? Arthur unlike the others had a court which myth made multiracial , french/scottish/welsh/english/irish/german knights all sat at the table in myth, this appealed to the future better than others. What is my point ? they happen because people in the future deem it relevant to their own passions. . Based on star trek discovery, what relevance did Sisqo and the prophets have to the survival of the federation? How did that survival relate to the survival or jake or cassidy and sisqo's second child or their bloodline? As a writer do I wish I was the one to make this happen? yes. Has paramount or skydance paramount shown they can positively manage adding to the literature of the the star trek global franchise ? no. I don't think star trek starfleet academy is bad. Nor do I hate the chris pine films. But, they all could had been better. My argument is they all lack the ambition of Roddenberry. As shatner's documentary proved, many people in paramount seem to think roddenberry was crazy and it shows in star trek after his death. Many have said academy is daring or of the times, but I oppose that sentiment. I think academy is written in an opportunistic way. It is not challenging the audience's perceptions but catering to what some in the audience want to see while also catering to what some in the audience don't want to see. IT isn't challenging the writers to really build an honest lens to something that hasn't been shown in a world that has multiple shows plus movies as part of its literary life.