When and how will Squeenix die?

Next 10 years

Insolvent to pay debt and files whatever the Japanese equivalent of Chapter 11 bankruptcy is

Survives bankruptcy but looks like a shell of its former self (including both the good era righter after the merger, and the fat bloated capitalist pig era)

Basically just like one dude sitting in an office licensing off their IPs to random other studios to make shitty games with