How to submit new analyses for Achilles (which SQL flavor to code)

[vojtechhuser]

In Achilles.sql file thare are many analyses. (most likely in SQL server flavor) (or what flavor exactly)
These get translated to postgres flavor using R package.

I would like to contribute new analyses. Probably some semi-final SQL code that gets incorporated by core developer.

For authoring new analyses, in which sql flavor should I author them?
(I need rounding of real number to integer and then to multiple of 5)
e.g., 21 rounded to 20
7 rounded to 5
6.3 rounded to 5

so it will be like x- (x % 5) (modulo function)

How sophisticated is the flavor translation?

[fdefalco]

Unfortunately you would have to dig through the guts of SQLRender to get a feel for the sophistication of the flavor translation right now. I would suggest looking at the existing queries in the Achilles for some indication of what it is capable of today.

The 'template' SQL format we use is closest to the MS SQL Server T-SQL implementation so I would advise authoring in the same format.

[t-abdul-basser]

Asked and answered.