Is there a way to know if a custom record is locked using suiteql?

not as far as I know. I assume you mean locked via Workflow? Since locked only applies to edit mode, and SuiteQL is readonly, I don’t think SuiteQL would trigger any lock checks.

Not necessary that scenario, you can have a custom record locked by definition from a bundle but yeah, I do not think we can get that from saved search nor suiteql. Thanks for replying