The native SPL syntax of esProc is much simpler than window functions, so there's not much need to support window functions anymore. esProc can also execute SQL in a command-line manner, such as the ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. - SPLWare/esProc ...