///| A conservative lexer: one statement, no transaction escape, reserved names

///|
/// cannot be reached through quoted identifiers or comments. SQLite parses SQL.
pub fn sql_allowed(sql : String) -> Bool {
  let bytes = @utf8.encode(sql)
  let tokens : Array[String] = []
  let mut i = 0
  let mut ended = false
  while i < bytes.length() {
    let c = bytes[i].to_int()
    if c <= 32 {
      i += 1
    } else if c == 45 && i + 1 < bytes.length() && bytes[i + 1] == b'-' {
      while i < bytes.length() && bytes[i] != b'\n' {
        i += 1
      }
    } else if c == 47 && i + 1 < bytes.length() && bytes[i + 1] == b'*' {
      i += 2
      while i + 1 < bytes.length() &&
            !(bytes[i] == b'*' && bytes[i + 1] == b'/') {
        i += 1
      }
      if i + 1 >= bytes.length() {
        return false
      }
      i += 2
    } else if ended {
      return false
    } else if c == 59 {
      ended = true
      i += 1
    } else if c == 34 || c == 39 || c == 96 || c == 91 {
      let end = if c == 91 { 93 } else { c }
      i += 1
      let word = @buffer.Buffer()
      let mut closed = false
      while i < bytes.length() {
        let b = bytes[i]
        i += 1
        if b.to_int() == end {
          if i < bytes.length() && bytes[i].to_int() == end && end != 93 {
            word.write_byte(b)
            i += 1
          } else {
            closed = true
            break
          }
        } else {
          word.write_byte(b)
        }
      }
      if !closed {
        return false
      }
      let token = @utf8.decode_lossy(word.to_bytes()).to_lower()
      if token.has_prefix("_bls_") ||
        token.has_prefix("_litestream_") ||
        token.has_prefix("__turso_") ||
        token.has_prefix("sqlite_") ||
        token == "load_extension" {
        return false
      }
      tokens.push("quoted")
    } else if (c >= 65 && c <= 90) || (c >= 97 && c <= 122) || c == 95 {
      let start = i
      while i < bytes.length() {
        let b = bytes[i].to_int()
        if (b >= 65 && b <= 90) ||
          (b >= 97 && b <= 122) ||
          (b >= 48 && b <= 57) ||
          b == 95 ||
          b >= 128 {
          i += 1
        } else {
          break
        }
      }
      let token = @utf8.decode_lossy(bytes[start:i]).to_lower()
      if token.has_prefix("_bls_") ||
        token.has_prefix("_litestream_") ||
        token.has_prefix("__turso_") ||
        token.has_prefix("sqlite_") ||
        token == "load_extension" {
        return false
      }
      tokens.push(token)
    } else {
      i += 1
    }
  }
  guard tokens.length() > 0 else { return false }
  match tokens[0] {
    "select"
    | "with"
    | "insert"
    | "update"
    | "delete"
    | "create"
    | "alter"
    | "drop"
    | "replace" => true
    _ => false
  }
}