@echo off
@if .%1.==.. goto syntax
 del foo.fdb  2>nul
del getdt.log 2>nul

set sql=gendt.sql
echo create database ' foo.fdb ' user 'sysdba' password 'masterke'; commit;>%sql%
@rem echo connect 'localhost:%~dp0foo.fdb' user 'sysdba' password 'masterke';>>%sql%
echo recreate table t0(x int); commit;>>%sql%
echo create index t_x on t0(x); commit;>>%sql%
echo insert into t0(x) values(1); commit;>>%sql%
echo insert into t0(x) values(2); commit;>>%sql%
echo select * from t0; commit;>>%sql%
echo connect 'foo.fdb' user 'sysdba' password 'masterke'; commit;>>%sql%
echo show version;>>%sql%
echo set stat on;>>%sql%
echo set list on;>>%sql%
echo set plan on;>>%sql%
echo -----------;>>%sql%

for /L %%i in (1, 1, %1) do ( echo select x,lag^(x^)over^(order by x^) x2,max^(x^)over^(partition by x^) mx from^(  >>%sql% )

echo select x from t0>>%sql%

for /L %%i in (1, 1, %1) do echo )z >>%sql%%

echo ;>>%sql%

echo set stat off;>>%sql%
echo out;>>%sql%

@rem isql -i %sql% -m -o getwid.log
@rem type getwid.log 2>nul
  goto end
:syntax
  @echo off
  cls
  echo use 1st arg as limit of derived tables depth
  pause>nul
  goto end
:end

create database 'foo.fdb' user 'sysdba' password 'masterke'; commit;
recreate table t0(x int); commit;
create index t_x on t0(x); commit;
insert into t0(x) values(1); commit;
insert into t0(x) values(2); commit;
select * from t0; commit;
connect 'foo.fdb' user 'sysdba' password 'masterke'; commit;
show version;
set stat on;
set list on;
set plan on;
-----------;
select x,lag(x)over(order by x) x2,max(x)over(partition by x) mx from(   
select x,lag(x)over(order by x) x2,max(x)over(partition by x) mx from(   
select x,lag(x)over(order by x) x2,max(x)over(partition by x) mx from(   
select x,lag(x)over(order by x) x2,max(x)over(partition by x) mx from(   
select x,lag(x)over(order by x) x2,max(x)over(partition by x) mx from(   
select x from t0
)z 
)z 
)z 
)z 
)z 
;
set stat off;
out;

C:\1Install\fb30>isql -q -i gendt.sql

           X
============
           1
           2

ISQL Version: WI-T3.0.0.30663 Firebird 3.0 Alpha 1
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30663 Firebird 3.0 Alpha 1"
on disk structure version 12.0

PLAN (Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z
 Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z T0 NATURAL)

X                               1
X2                              <null>
MX                              1

X                               2
X2                              1
MX                              2


Current memory = 596668424
Delta memory = 13472488
Max memory = 620464336
Elapsed time= 0.12 sec
Buffers = 131072
Reads = 28
Writes 0
Fetches = 195