The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause.

CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQLGrammar-usagecreateDDLProcedure

Should be able to parse the following and set the EMF Description (Annotation) value when imported into Designer

CREATE FOREIGN PROCEDURE ProcedureWithRS (
   newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'), 
   newParameter_2 string(4000)
) RETURNS string(255) OPTIONS(ANNOTATION 'Example')