deploy `long_windows` sql return deploy status

[zhanghaohit]

Describe the feature you'd like

we should have a mechanism to tell the users whether they are using the long_window optimization or not for a deployment.