Hello Rohan !
It is also one of the questions that I have in mind and I was checking the doc but unfortunately real time mode does not support delta tables as either a source or sink and lakeflow spark declarative pipelines are also not supported in real time mode.
I tried to find any public ETA for it but in vain.
The closest declarative alternative today is lakeflow spark declarative pipelines with streaming tables in continuous mode which Databricks positions for freshness on the order of seconds to a few minutes and for sub-second latency, the current path is still structured streaming real time mode with supported sources such as kafka or event hubs rather than delta.
Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP