There are two specific restrictions in Firebird:
1. You can not create a command that require new transactions inside an existed transactions (there is a way to solve it though, using autonomous transactions)

2. You can not change structure in execution block (stored procedures, anonymous procedure like the last link and triggers), however you can use the execute block instead.

Here is the way you suggested it that works btw, and you are right, but still I’ve created a new table inside an execution block 🙂

SET TERM !! ;

EXECUTE BLOCK AS
declare a_name varchar(10) = ‘EMPLOYEE’;
BEGIN
if (not exists(select 1 from rdb$relations where rdb$relation_name = :a_name)) then
execute statement ‘create table ‘ || :a_name ||’ ( id integer ); ‘;
END!!

SET TERM ; !!
commit;

The double pipe is the concat action.
In theory I can also create the table inside the system tables with insert, but that way, it’s cleaner.

Like all databases, it’s not perfect, but I really like the power. I really hope that Mysql based will be better in that area, instead of using external tools such as yours.

Your work is very good, but I really prefer such tools as part of the database itself, instead of external plugins.

Thank you. I am well aware of other databases capabilities, including, for example, PostgreSQL’s python/perl/… language routines, which make for a much easier scripting capabilities.
There are some advantages to QueryScript (including some I’m still working on and are not released yet) over existing implementations. But, I would say, if I were to come from the PstgreSQL world, I would probably not have the urge to embark upon this coding mission.

I have no immediate intentions for any specific database other than MySQL. But as I created a language, I decided it should, by definition, be a general one.
I do not presume that this language will catch with other databases, but am interested in leaving this open.

Regards,
Shlomi

this is a very interesting feature for MySQL you have written. It is for sure not needed on PostgreSQL. But if you use MySQL it will be very nice indeed to do some things on the server – not in the client.

Regards,
Holger

But to pursue the subject you present with table creation via dynamic SQL: the invocation of a ‘create table …’ string, dynamically executed. This means this ability is not integrated into the code. If you wanted the table name to be dynamic, you would have to make for text manipulation (using CONCAT() or whatever). Same goes for MySQL, and it’s one of the things that make MySQL server side scripting a mess.
Server side cursors are somewhat easier on firebird than on mysql, but still you have to declare-open-loop-fetch-check-exit-close.

That is not to say I’m arguing against the firebird coding (as I suspect you are inclined to believe). But when you say FB “has all that” – I would rather be more precise on that.

Also Fb and PostgreSQL support afaik temporary tables just for the execution block that will be removed when the block is done executing

On FB PSQL have all of that, and on Postgre, we additional programming language to use in stored procedure.

Here is how you declare a variable: http://www.firebirdsql.org/refdocs/langrefupd25-psql-declare.html

Another example, this is for flow usage:
http://www.firebirdsql.org/manual/nullguide-conditionals-loops.html