periods in string split string

[bobbymannino]

if you have a string "bonobo.bob@bom.com" no matter how you insert it;

"sqlcall new_user(${email})" "sqlcall new_user(${sql(email)})"

I end up with the sql call new_user ("bonobo"."bob@bom"."com")

Why is this happening? im sure its me but I cant figure out why?

[chiuwah]

If you put the email in an object and then insert it in the sql request, it should work:

const user = { email: 'bonobo.bob@bom.com' }

await sql`insert into users ${ sql(user, 'email') }`