Native. Secure. Direct Queries.

SELECT
  p.name                                   AS period,
  -- Current Ratio
  ROUND(
    SUM(CASE WHEN a.accttype = 'OthCurrAsset' OR a.accttype = 'Bank'
         THEN tl.amount ELSE 0 END) /
    NULLIF(SUM(CASE WHEN a.accttype = 'OthCurrLiab' OR a.accttype = 'AcctPay'
         THEN ABS(tl.amount) ELSE 0 END), 0)
  , 2)                                     AS current_ratio,
  -- Quick Ratio
  ROUND(
    SUM(CASE WHEN a.accttype = 'Bank' OR a.accttype = 'AcctRec'
         THEN tl.amount ELSE 0 END) /
    NULLIF(SUM(CASE WHEN a.accttype = 'OthCurrLiab' OR a.accttype = 'AcctPay'
         THEN ABS(tl.amount) ELSE 0 END), 0)
  , 2)                                     AS quick_ratio,
  -- Working Capital
  SUM(CASE WHEN a.accttype IN ('OthCurrAsset','Bank','AcctRec')
       THEN tl.amount ELSE 0 END) -
  SUM(CASE WHEN a.accttype IN ('OthCurrLiab','AcctPay')
       THEN ABS(tl.amount) ELSE 0 END)    AS working_capital
FROM
  TransactionLine tl
  INNER JOIN Transaction t  ON tl.transaction = t.id
  INNER JOIN Account a      ON tl.account = a.id
  INNER JOIN AccountingPeriod p ON t.postingperiod = p.id
WHERE
  t.posting = 'T'
  AND p.isyear = 'F' AND p.isquarter = 'F'
GROUP BY p.name
ORDER BY p.name DESC
FETCH FIRST 12 ROWS ONLY