SQL

SQL feature can be used in case you need to create a report that can't be created from the current models and share it with your teams. It enables you to see the underlying data layout and create reports using SQL but the reports that you created via SQL won't be composable. Therefore we advise you to create models from the SQL definitions and make your users be able to use the models from our Segmentation, Funnel, and Retention.

Rakam is not a SQL editor in general so we don't actually focus on this feature that much. On the other hand, since it supports almost all the SQL Context, you can write Jinja variables, compile & execute the SQL queries, and see the result in real-time.