Firebird 3.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select rdb$get_context('SYSTEM', 'ENGINE_VERSION') as version
     , rdb$character_set_name
from rdb$database;

VERSION
RDB$CHARACTER_SET_NAME

3.0.14
UTF8

-- Firebird 3.0 brought the BOOLEAN type and IDENTITY columns
create table task (id integer generated by default as identity primary key
                 , name varchar(20), done boolean);
insert into task (name, done) values ('write', true);
insert into task (name, done) values ('ship', false);

1 row affected

1 row affected

select id, name, done from task order by id;

ID
NAME
DONE

1
write
TRUE

2
ship
FALSE

-- window functions also arrived in 3.0
select name, count(*) over () as tasks_in_all from task order by id;

NAME
TASKS_IN_ALL

write
2

ship
2