Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • 1
    Another unfortunate caveat is SQL non-portability. You can't generally build SQL string in one portion of code and send it to a DB in another place. In ideal world that should be possible — SQL is a query language, literals are the bedrock of query languages, and ANSI SQL standardized things like identifier and string literal syntax decades ago. Alas 😭. DBs have incompatible extensions to literal syntax, and what's worse options like MySQL's NO_BACKSLASH_ESCAPES may be a dynamic property of DB connection (SET SESSION sql_mode, with admin-controlled defaults to make it worse). Commented Dec 22, 2022 at 0:17
  • 100% i will add some extras Commented Dec 22, 2022 at 10:30
  • What is it about views that creates an edge case in this context? Commented Dec 22, 2022 at 17:21
  • I guess its more that you only have one target per type, presumably you have a table with the data but you might have a number of views of the data with different names Commented Dec 22, 2022 at 17:56