MariaDB 10.3

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

create table tbl (id int);
insert into tbl values (1);
select id as rows from tbl;
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows from tbl' at line 1

select id as 'rows' from tbl;

rows

1

select id as "rows" from tbl;

rows

1

select id as `rows` from tbl;

rows

1