Cumulative product for a random walk in QuestDB SQL

I have a dataset in QuestDB with daily returns for a stock, starting at $100. I want to calculate the cumulative product of the returns to simulate the stock's price path (random walk). The daily returns are stored in a table called daily_returns.

Here’s a sample of the relevant columns:

I'm trying to calculate the cumulative product of (1 + return) for each day, starting from $100. This would be the expected output

I know QuestDB doesn't have a direct cumulative product function, and I found this nice trick (maths to the rescue!) where you can use a window function and get the exponent of the sum of the logarithms for each day, and that would be the same as a cumulative product.

Problem is that QuestDB does not allow to use any functions on top of a Window Function result, so when I do:

 SELECT 
        date,
        return,
        exp(sum(ln(1 + return)) OVER (ORDER BY date)) AS StockPrice
    FROM daily_returns

I get an error "dangling literal".

Any workarounds here or cannot cumulative product can be calculated using QuestDB?

Even if we cannot use exp on top of a window function, it doesn't mean we cannot still use a cumulative SUM on a CTE and then use exp for every row.

WITH ln_values AS (
    SELECT 
        date,
        return,
        SUM(ln(1 + return)) OVER (ORDER BY date) AS ln_value
    FROM daily_returns
)
SELECT 
    date,
    return,
    100 * exp(ln_value) AS "StockPrice"
FROM ln_values;

And this is the outcome