How to add single quote in concat function

[Gyanaranjan1993]

How do I be able to add a single quote in the middle of string through concat function?

Sample Input

 [ 
 {
       "PhysicalId": "220000110147"
  }
 ]

Expected O/P :

    {
        "carrierId_lookup" : "select id from carrier where physicalId = '220000110147' "
   }

Spec:

[
 "operation": "modify-default-beta"
 "spec": {
        "*": {
            "carrierId_lookup": "=concat('SELECT c.id FROM Carrier c WHERE c.physicalId=', @(1,physicalId)) "
          }
     }
]

Actual O/P:

    {
        "carrierId_lookup" : "select id from carrier where physicalId =220000110147"
   }