Preserve valid identifiers in SQL-DF import
- Dominant language
- Common Lisp
- Stars
- 2
- Forks
- 1
- PR merge metrics
- No merged PRs in 30d
Description
### Discussed in https://github.com/Lisp-Stat/lisp-stat/discussions/24
Originally posted by **gassechen** September 27, 2023
Hello, I have a question.
If I use pprint to print the data frame these are the results
```
(pprint df2)
;; ESN ASSET_ID
;; 0-4513034 672061
;; 2-3211115 609473
```
but if I use them with sqldf they are these
```
(pprint (sqldf:sqldf "select esn,ASSET_ID from DF2 limit 10"))
;; ESN ASSET-ID
;; 0-4513034 672061
;; 2-3211115 609473
```
It is changing the names of the keys
` ASSET_ID --> ASSET-ID`
SQL-DF permanently modifies identifiers into idiomatic lisp format, even those that are valid lisp identifiers, but non-idiomatic. This should be configurable.
Contributor guide
Research direction
Start at the sqldf:sqldf entry point and trace how SQL-DF result identifiers are converted, using the ASSET_ID example from the issue. Done means valid identifiers such as ASSET_ID are preserved by default or can be preserved through a configuration option, without losing the existing idiomatic conversion behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, sqlite
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100