请教一下，如何在Android里面实现该SQLite语句

请教一下，如何在Android里面实现该SQLite语句（来自邹健老师）

INSERT #re(
  path,
  state_count, line_count,
  start_lineID, start_state,
  current_lineID, current_state,
  next_orderid, flag, lineIDs, level)  
  -- 同一LineID
  SELECT
  path = CONVERT(nvarchar(max),
  A.path
  + N'->'
  + RTRIM(B.orderid) + N'.' + B.state
  ),
  state_count = A.state_count + 1,
  A.line_count,
  A.start_lineID, A.start_state,
  current_lineID = B.lineID,
  current_state = B.state,
  next_orderid = B.orderid + A.flag,
  flag = CASE
  WHEN B.state = @state_stop THEN 0
  ELSE A.flag END,
  A.lineIDs,
  level = @level
  FROM #re A, #tb B
  WHERE A.flag <> 0
  AND A.level = @level - 1
  AND A.current_lineID = B.lineID
  AND A.next_orderid = B.orderid

建议去其他数据库版问问