ruby-on-rails - Rails SQLite SQLException：无法识别的令牌：sql查询中的“#”

Question

我在带有 SQLite 数据库的 Rails 中使用 sql 查询。

sql = "SELECT 'projects'.* FROM 'projects' INNER JOIN 'projects_users' ON 'projects_users'.'project_id' = 'projects'.'id' INNER JOIN 'users' ON 'users'.'id' = 'projects_users'.'user_id' WHERE 'projects'.'client_id' = #{@user} or 'projects_users'.'user_id' = #{@user};"
all = ActiveRecord::Base.connection.execute(sql)

它返回错误SQLite3::SQLException: unrecognized token: "#"

标签： ruby-on-railssqliteactiverecord