Invalid column name 'sysadmin'

[starley00]

Invalid column name 'sysadmin'

[Tw1sm]

That is expected behavior - you need to use double quotes around your query if you are using single quotes inside it "select is_srvrolemember('sysadmin')"

poetry run pysqlrecon --quiet --dc-ip 192.168.0.235 -d redania.local -u user -p Password1 -t 192.168.0.235 query --query "select is_srvrolemember('sysadmin')"
[13:08:27] INFO     Connecting to 192.168.0.235:1433
[13:08:27] INFO     Executing custom query on 192.168.0.235

┏━━━┓
┃   ┃
┡━━━┩
│ 0 │
└───┘