I tried to add this on connectivity/source/parse/sqlflex.l
TERM                {SQL_NEW_KEYWORD(SQL_TOKEN_TERM);  }

but then I'm stuck with Bison part.
I don't know at all Lex/Flex and Bison.

Lionel: any idea?

If using an embedded HypersonicSQL databse SET TERM is not an HSQL command.

To pass a command to a linked database go into the query design view. Enter command and click "Run SQL Command Directly".

See Wiki entries:
https://help.libreoffice.org/Common/Run_SQL_command_directly
https://help.libreoffice.org/Common/Executing_SQL_Commands
https://help.libreoffice.org/Common/Execute_SQL_statement

Please verify this gives expected results.

(In reply to comment #2)
...
> To pass a command to a linked database go into the query design view. Enter
> command and click "Run SQL Command Directly".
> 
> See Wiki entries:
> https://help.libreoffice.org/Common/Run_SQL_command_directly
> https://help.libreoffice.org/Common/Executing_SQL_Commands
> https://help.libreoffice.org/Common/Execute_SQL_statement
> 
> Please verify this gives expected results.

I don't see the "Run Sql command directly", can you attach a screenshot or give precise steps. The wiki entry didn't help me :-(

Created attachment 101779 [details]
Screen capture of how to execute running an SQL command directly

Thank you for your help!

Now when running the sql without "run direct sql", I got:
SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

and with it, I've got:
Error code: 1

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 5
*term
caused by
'isc_dsql_prepare'

@Julien Nabet:
SET TERM is not a Firebird SQL command but a client (isql, Flamerobin,...) command so it is expected that you get an SQL error from the server.
See http://www.firebirdfaq.org/faq78/

Note: most Firebird DDL scripts with trigger/stored procedure/generator creation will use SET TERM so having the ability to parse this would be useful in Libreoffice. 

*If* Libreoffice is not able to parse a script like this:
CREATE PROCEDURE givetheanswer
RETURNS (ANSWER INTEGER)
AS 
BEGIN
  -- bigger procedures often need comments.
  FOR
    select 42 from rdb$database into :ANSWER
  DO
    SUSPEND;
END^

... then parsing SET TERM would be *necessary*:
SET TERM ^ ;

CREATE PROCEDURE givetheanswer
RETURNS (ANSWER INTEGER)
AS 
BEGIN
  -- bigger procedures often need comments.
  FOR
    select 42 from rdb$database into :ANSWER
  DO
    SUSPEND;
END^

SET TERM ; ^

Sorry, cannot test myself, don't have working Firebird connectivity with my LibreOffice.

(In reply to reinierolislagers from comment #6)
> Sorry, cannot test myself, don't have working Firebird connectivity with my
> LibreOffice.
Firebird support is experimental. To enable it, you must do:
- Tools/Options/Advanced
- check "Enable experimental features"
- restart LibreOffice

I know. I'm facing bug 84618.

(In reply to reinierolislagers from comment #6)
> *If* Libreoffice is not able to parse a script like this:
> CREATE PROCEDURE givetheanswer
> RETURNS (ANSWER INTEGER)
> AS 
> BEGIN
>   -- bigger procedures often need comments.
>   FOR
>     select 42 from rdb$database into :ANSWER
>   DO
>     SUSPEND;
> END^


Oops, that should have been the last end without ^
CREATE PROCEDURE givetheanswer
RETURNS (ANSWER INTEGER)
AS 
BEGIN
  -- bigger procedures often need comments.
  FOR
    select 42 from rdb$database into :ANSWER
  DO
    SUSPEND;
END;

Just created a new query, set SQL mode to true and ran it. Although the query complained about not returning a result set, that was the only error.
I tried calling the created stored procedure with this query:
select answer from givetheanswer
standard mode gave The statement contains a cyclic reference to one or more subqueries
Native SQL mode: Table not found in statement [SELECT answer FROM gettheanswer]
This query does work in Firebird tools (e.g. Flamerobin).

Adding database with queries (test3.odb).

Created attachment 107408 [details]
Test database with create stored procedure query and query getting stored proc result

Your test database is an HSQLDB database, but seems to try to be using Firebird syntax. Try it on a firebird DB and it will work, if you change the "givetheanswer" to proper upper case, that is:
 SELECT "ANSWER" FROM "GIVETHEANSWER"

Saved queries in LibreOffice are rather hardcoded/expected to be SELECT-type queries, that return a result. As such, maybe the "no result returned" message overrides another error message. I didn't check if that is what is happening in in your example; if it is, this is unfortunate, but then it is another bug than what is discussed here.

For action queries, I'd rather recommend menu Tools / SQL, or executing by a scroipt (using "execute" and/or "executeUpdate" instad of "executeQuery").

"SET TERM" is not necessary in LibreOffice because whether in a saved query or in Tools/SQL, the whole string is passed as one command (statement) to the database. That is, LibreOffice always uses *no* statement terminator, so no need to change it.

The examples that need SET TERM in isql / flamerobin / ... should work without it in LibreOffice, *if* they are being executed one by one in the LibreOffice environment.

Lionel: I created this tracker reading this:
https://bugs.freedesktop.org/show_bug.cgi?id=69949#c6 (see https://bugs.freedesktop.org/show_bug.cgi?id=69949#c15)