In ESQL, the SUBSTRING function allows negative start positions, where -1 refers to the last character. This is similar to Python's negative indexing but differs from SQL standards. A negative start counts backward from the string's end, enabling flexible substring extraction.